|
View previous topic :: View next topic
|
| Author |
Message |
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hi,
In my PLI DB2 program , I am trying to insert a row in to a DB2 table and it is giving me SOC4 abend on the insert statement. But the same row is getting inserted whn i try it through SPUFI.
The abend is as follows :
IBM0534S ONCODE=8094 PROTECTION EXCEPTION
INFORMATION FOR THREAD 8000000000000000
TRACEBACK:
DSA ENTRY E OFFSET STATEMENT LOAD MOD PROGRAM UNIT
1 CEEHDSP +000041E2 CEEPLPKA CEEHDSP
Can anyone help ? Thanks. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
does the abend occur at the FIRST invocation of a DB2 service ?
if yes check the linkage editor for unresolved VCONS and AMODE/RMODE settings |
|
| Back to top |
|
|
Appu
New User
Joined: 26 Apr 2010
Posts: 73
Location: India
|
|
|
|
Hi ,
The insert is the 2nd statement . The previous SQL statement like Include SQLCA worked fine returning sqlcode 0.
Link step went fine . I could see AMODE and RMODE are NOT SPECIFIED.
No VCONS are unresolved. Only thebelow ones are unresolved.
IBMQOFNT
IBMQOFPT
DSNHLI
IBMQEFSH
IBMPOFCX
IBMPINPL
CEESG011
CEEBETBL
CEEROOTA
CEEOPIPI |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| Link step went fine |
please define fine
what is the return code from the linkage editor ?
anyway do You, your support realize that DSNHLI is the interface stub for DB2
and that it is not supposed to be uresolved!
work with Your support to setup a proper ( compile/link) procedure |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| The previous SQL statement like Include SQLCA worked fine returning sqlcode 0 |
How do you know that there was an sqlcode of 0 returned for the INCLUDE SQLCA statement? |
|
| Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
Sorry for posting late, but this thread ended appearently unresolved.
| Appu wrote: |
Hi ,
The insert is the 2nd statement . The previous SQL statement like Include SQLCA worked fine returning sqlcode 0.
Link step went fine . I could see AMODE and RMODE are NOT SPECIFIED.
No VCONS are unresolved. Only thebelow ones are unresolved.
IBMQOFNT
IBMQOFPT
DSNHLI
IBMQEFSH
IBMPOFCX
IBMPINPL
CEESG011
CEEBETBL
CEEROOTA
CEEOPIPI |
The INCLUDE SQLCA statement does not execute any code at runtime, so I assume that the INSERT statement is after all the first DB2 call when you execute your program.
I think your problem is calling the wrong DB2 connect module. The entry point DSNHLI is contained in multiple connect modules that are used for different runtime environments. For TSO batch interface (IKJEFTxx), you should load or link module DSNELI.
For further info on this, reference your current DB2 Application Programming Guide manual. |
|
| Back to top |
|
|
|
|
