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
 
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: 193
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 The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts How to get complete URL from CICS Con... mbattu CICS 1 Tue Nov 14, 2017 11:59 pm
No new posts Integrating CICS applications craig2020 CICS 1 Sun Oct 29, 2017 6:49 pm

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