MVSFORUMS.com

VINAY19 · Beginner Joined: 14 Jan 2008 Posts: 4 Topics: 2

Hi all,

I am testing cobol-cics-db2 program. I have compiled, bound the program successfully. I know i have access to the plan to which the program is bound also the collection id bound to this plan is valid for the tables which are accessed in the program.

But the problem is when i try running the program in CICS test region I am getting SQLCODE as -922 for an open cursor statement.

Can anyone tell me what might be the cause for the problem. I feel it has something to do with the region. I am new to cics so if anyone can let me is there anything like we need to bind the region to that plan???

Also how do i check the RCT entry for this program.

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

VINAY19,

What is the SQLERRMC code in your error message? Do a QW with the SQLERRMC code and it will give yo the reason for failure.

You can check the below link for more explanation.

http://www.mvsforums.com/helpboards/viewtopic.php?t=4743&highlight=sqlcode+922

jsharon1248 · Posted: Mon Jan 28, 2008 10:41 am Post subject:

You also need to be aware of dynamic plan selection. Look through the RCT discussion in the CICS Resource Definition Guide.

VINAY19 · Beginner Joined: 14 Jan 2008 Posts: 4 Topics: 2

thanks a lot for ur replies...