SQL CODE : 0000081Q



IBM's flagship relational database management system

SQL CODE : 0000081Q

Postby kiran_q » Mon Nov 24, 2008 10:45 pm

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.
kiran_q
 
Posts: 9
Joined: Wed Nov 12, 2008 8:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL CODE : 0000081Q

Postby dick scherrer » Tue Nov 25, 2008 2:56 am

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: SQL CODE : 0000081Q

Postby kiran_q » Tue Nov 25, 2008 1:38 pm

thank you

the problem got resolved, the JCL was pointing to wrong RM library.
kiran_q
 
Posts: 9
Joined: Wed Nov 12, 2008 8:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL CODE : 0000081Q

Postby dick scherrer » Wed Nov 26, 2008 2:09 am

You're welcome :)

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

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post