View previous topic :: View next topic
|
Author |
Message |
biswa.pandab
New User
Joined: 17 Sep 2005 Posts: 1 Location: Bangalore
|
|
|
|
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
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you talk with your dba.
Is this program intended to use the Call Attachment Facility (CAF)? |
|
Back to top |
|
|
|