Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
-991/-927 sql code.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
biswa.pandab

New User


Joined: 17 Sep 2005
Posts: 1
Location: Bangalore

PostPosted: Sat Aug 23, 2008 3:17 am    Post subject: -991/-927 sql code.
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Aug 23, 2008 5:50 am    Post subject:
Reply with quote

Hello,

Suggest you talk with your dba.

Is this program intended to use the Call Attachment Facility (CAF)?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IBEGENER RETURN CODE 12 anilkumar922 All Other Mainframe Topics 5 Wed Dec 13, 2017 11:41 am
No new posts Finding the plan when code compiled u... Ahemad DB2 1 Fri Dec 01, 2017 6:38 pm
No new posts Strange Code amitc23 COBOL Programming 6 Tue Nov 28, 2017 11:25 am
No new posts Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us