View previous topic :: View next topic
|
Author |
Message |
simha_it
New User
Joined: 05 May 2005 Posts: 30
|
|
|
|
Hi
I am getting SQLCODE = -501 (ERROR: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN) when I was fetching the next row from a Cursor. Ihave declared a cursor with 'WITH HOLD option and not issuing any commit with in the program.
Please suggest me the solution for this... |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you have a bug in the program that causes you to perform a FETCH after you have issued a CLOSE to the cursor.
no doubt about it. |
|
Back to top |
|
|
simha_it
New User
Joined: 05 May 2005 Posts: 30
|
|
|
|
I don't have any Close statement in the processing except at the end of the program. Is it possible, DB2 will issue a Commit internally because of any reasons?? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
No.
You're not writing pseudo-conversational stuff ?
Do you do an open cursor ?
Have you missed a previous sqlcode and try to fetch again ?
SQLCODES -404, -652, -679, -802, -901, -904, -909, -910, -911, -913, and -952 and maybe some others may close cursors |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
Is it possible, DB2 will issue a Commit internally because of any reasons?? |
only when the program exits and control returns to the operating system.
either you are performing the close statement and then are fetching again,
or
you did not open the cursor,
or
your cursor open statement did not receive an sqlcode of 0.
you have a bug....stop trying to find a problem with db2. your problem is in your code.... |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Quote: |
your cursor open statement did not receive an sqlcode of 0. |
Damn, missed that one. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
Damn, missed that one. |
Hell, I missed all the others.
the program probably does not check sqlcodes after all sql statements. |
|
Back to top |
|
|
|