Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us