Db2 cursor open error

vijaybhaskarnvn · New User Joined: 22 Oct 2005 Posts: 3 Location: hyderabad

i was getting cursor open error 80

can any body solve it.

<<<E-Mail ID Removed>>> Read Forum Rules.

priyesh.agrawal · Posted: Mon Nov 07, 2005 9:02 pm

What is the error message you are getting and what is the SQL Code for that query ?

Is this error while OPENING cursor or FETCHING or CLOSING.

Regards,

Priyesh.

ikumar · New User Joined: 02 Aug 2005 Posts: 81

there is no sqlcode 80 exists...post the correct code....

Thanks,
Kumar.

vijaybhaskarnvn · New User Joined: 22 Oct 2005 Posts: 3 Location: hyderabad

Hai this is bhaskar.

I was updating the table through cursor.

there i declared

execsql
open cursor
end-exec.
If sqlcode < 0
display "cursor open error", sqlcode
end-if.

i got code cursor open error 000000000080

in this way i got the error

plz kindly replyme

nikyojin · New User Joined: 05 Oct 2005 Posts: 94

Hi Bhaskar,
I think the Sqlcode u got is in hexadecimal notation..Probably it is 80H which probably means -805. This problem is related to Bind. Pls bind the the pgm to the proper plan.
Hope this helps.If not pls give me the details....

Thanks,
Nikhil .S.