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 UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm


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