MVSFORUMS.com

[nadh]

Hi,

what is SQLCODE -504. i came to know that it comes when curssor name is invalid. i need complete details regarding that. when it occurs and how to resolve that.

thanks
nadh

[SureshKumar]

nadh,
It occurs when you don't declare the cursor and try to open it. Declare the cursor to resolve it.

[kolusu]

nadh,

Check this link for a detailed explanation of the error -504

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.196?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[nadh]

Kolusu,

if we don't declare the cursor and try to open it, at bind time we will get abend right. Pls. clarify. if we declare the cursor by one name and try to open with other name what will happen.

nadh.

[kolusu]

Nadh,

If you don't declare a cursor and try to open it then you will get an error during the pre-compilation it self. And the reverse is also true, if you try to open a cursor without defining it , then your will get an error during pre-compilation itself.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Raghesh]

Hi all,
I am new to the group and I am going to share my exp on -504.

It happens when you are using cursor processing in db2 .
consider these screnerios.
1.
You have opened the cursor .

now you are fetching it and doing some processing.
After some time you are taking checkpoint to commit your operation.
Again you try to fetch it and you will get a -504 as the cursor table is closed because of commit.
soln: use with hold in your declare statement.

2.you have tried to close the cursor with out opening it.

There can be other scenerios also but these are the ones I faced.
Hope this helps.
Raghesh Gopinath