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
 

 

SQLCODE -805 in CICS-DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Paul1983

New User


Joined: 08 Jul 2008
Posts: 37
Location: bangy

PostPosted: Tue Aug 04, 2009 11:03 pm    Post subject: SQLCODE -805 in CICS-DB2 program
Reply with quote

Hi,

I'm getting SQLCODE -805 in Program B, when trying to do an XCTL from program A after executing a DB2 query. When I'm intertesting the same in Program B, I can see in the SQLERRMC , the plan of Program A still instead of Program B. Can anyone help me out please in resolving this?

Thanks,
Paul
Back to top
View user's profile Send private message

Binop B

Active User


Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN

PostPosted: Wed Aug 05, 2009 3:44 pm    Post subject:
Reply with quote

Hi Paul,

Could u please update us on the PCT and RCT entries for all the programs and transactions related to Program A and Program B.
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Mon Aug 10, 2009 7:32 pm    Post subject: Reply to: SQLCODE -805 in CICS-DB2 program
Reply with quote

Hi Paul
Your problem can be rectified in two ways.
1). Add a statement in the program B after the PROCEDURE DIVISION.
MOVE 'TXID' TO EIBTRNID -- TXID is the transaction id of the pgm B.
2). Issue a CICS statement in the begining of the program.
EXEC CICS
RETURN TRANSID(TXID) COMMARE(COMM-AREA)
END-EXEC.
Here TXID is the transaction id of the prog B.

Before that make sure that the program B is having a TXID and its corresponding PLAN name.

Regards
Raghu
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm


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