| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
biswa.pandab
Joined: 17 Sep 2005
Posts: 1
Location: Bangalore
|
| Posted: Sat Aug 23, 2008 3:17 am Post subject: -991/-927 sql code. |
|
|
HI
I am working on a Stored Procedure and from Stored Procedure we are calling a Cobol-Db2 program-2 and that programs is updating/inserting into Database.
but currently that cobol-db2 program-2 is called by another cobol-db2 program-1 (batch Job)
Problem -
i am getting a Sqlcode- -927 for the SP whilei am calling the first Sql statment of the Cobol-Db2 program-2
Previouly their is No LCT for that Cobol-Db2 program-2
so i created two LCT
1.
INCLUDE SYSLIB(DSNALI)
NAME Cobol-Db2 program-2(R)
after that i change the LCT for the Cobol-Db2 program-2 to
2.
REPLACE DSNALI
INCLUDE INCLIB(Cobol-Db2 program-2)
INCLUDE SYSLIB(DSNRLI)
NAME Cobol-Db2 program-2(R)
after relinking the program the Stored procedure is working fine
but i am getting an sqlcode -991 while i am running the batch job for Cobol-Db2 program-1 .
How i have to resolve the -991 sqlcode.
Can any one help me on this issues.
and it is failed in the first sql statment in the atch program |
|
| Back to top |
|
dick scherrer
Joined: 23 Nov 2006
Posts: 8733
Location: 221 B Baker St
|
| Posted: Sat Aug 23, 2008 5:50 am Post subject: |
|
|
Hello,
Suggest you talk with your dba.
Is this program intended to use the Call Attachment Facility (CAF)? |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
