IBM Mainframe Forum

Hi All,

I am editting a CICS program which is using a table 'AAA' . The program when run in production CICS uses the production table and when run in Test uses corresponding test 'AAA' table.

I have created table 'AAA' in test region , with creator as my "User id " .
Now my requirement is : I have to test the CICS program in test regions and the program has to use the test table created by me instead of the original test table .

Original Cursor statament :


I have edited it to


When i tried to compile , it got compiled, but it got failed while binding . I guess am not supposed to mention the qualifier of teh table explicitly in the CICS program .

Can you please suggest me how i can resolve this , is their any setting in CICS where i can edit my tran settings to use the table i wish ?

Thanks Nara

Do not change the program. With DB2 one of the 'selling points' is minimal coding changes when something changes. You bind it to your table's ID.

BTW it would have been a good idea in your heading to say DB2 table to avoid people thinking it was a COBOL internal table which was not obvious until seeing your code.

Hi NicC,

I have binded my program using the below code :



The bind was successfull , checked whether the tran is using my table, but it is using the same old test table.
Did a new copy of the tran, still i got the same result.

Checked with my CICS site admin, could see that the DB2 entry for the CICS transaction is pointing to a different plan , so do i need to use the esisting plan defined for the tran and rebind the program ?

Thanks