|
View previous topic :: View next topic
|
| Author |
Message |
Paul1983
New User
Joined: 08 Jul 2008
Posts: 37
Location: bangy
|
|
|
|
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 |
|
 |
Binop B
Active User
Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN
|
|
|
|
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 |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
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 |
|
|
|
|
