Page 1 of 1

SQL CODE : 0000081Q

PostPosted: Mon Nov 24, 2008 10:45 pm
by kiran_q
HI,

while opening an cursor for one particular correlated SOL statement, am getting SQLCODE STATUS as 00000081Q. I tried many up and down things but not able to resolve can anyone please help me out. :?:

:arrow: i have moved key values to host variables before opening the cursor.

Re: SQL CODE : 0000081Q

PostPosted: Tue Nov 25, 2008 2:56 am
by dick scherrer
Hello,

Did you look up what causes a -818 (81Q is a -818)?

Here is the link to the db2 return codes manual:
http://publibz.boulder.ibm.com/cgi-bin/ ... /2.1.7.298?

Re: SQL CODE : 0000081Q

PostPosted: Tue Nov 25, 2008 1:38 pm
by kiran_q
thank you

the problem got resolved, the JCL was pointing to wrong RM library.

Re: SQL CODE : 0000081Q

PostPosted: Wed Nov 26, 2008 2:09 am
by dick scherrer
You're welcome :)

Good to hear it is working - thank you for letting us know 8-)

d