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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts INDEPENDENT CICS TS 4.1 MRO REGION UP... Kyle Carroll CICS 0 Wed Dec 14, 2016 6:55 pm
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm


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