IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to resolve the sql code -501


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Wed Jan 02, 2008 10:08 am
Reply with quote

hai pls explain me how to resolve the sql code -501.
Back to top
View user's profile Send private message
ousep143

New User


Joined: 06 Oct 2007
Posts: 32
Location: India

PostPosted: Wed Jan 02, 2008 10:31 am
Reply with quote

Hi Chandra,
Without opening a cursor,you have to fetch or close the cursor.Before fetch the data from DB2,you must open the cursor.

Regards
icon_smile.gif
Back to top
View user's profile Send private message
kovur

New User


Joined: 15 Nov 2007
Posts: 36
Location: India

PostPosted: Wed Jan 02, 2008 11:36 am
Reply with quote

Explanation: The application program attempted to either:

FETCH using a cursor, or

CLOSE a cursor


at a time when the specified cursor was not open.
System Action: The statement cannot be executed.

Programmer Response: Check for a previous SQL return code that may have closed the cursor. Commit and rollback operations close cursors. SQLCODES -404, -652, -679, -802, -901, -904, -909, -910, -911, -913, and -952 may force the cursor to close. After the cursor is closed, any fetches or close cursor statements will receive this SQLCODE -501.

If no previous SQL return codes have been issued, correct the logic of the application program to ensure that the cursor is open at the time the FETCH or CLOSE statement is executed.
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Wed Jan 02, 2008 1:52 pm
Reply with quote

Hi,

Description of error is "-501 Cursor not open on FETCH". Description itself is self-explanatory.
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Fri Jan 04, 2008 7:52 am
Reply with quote

Hai frends i know -501 is the cursor problem i just want to how to resolve that one, please explain me
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Jan 04, 2008 8:21 am
Reply with quote

chandracdac wrote:
Hai frends i know -501 is the cursor problem i just want to how to resolve that one, please explain me


OPEN the cursor before you do a fetch!
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Fri Jan 04, 2008 2:58 pm
Reply with quote

Chandra,

If you still couldn't understand the solution, post your code. We can provide the solution.

KSK
Back to top
View user's profile Send private message
rag swain

New User


Joined: 17 Dec 2007
Posts: 33
Location: pune,INDIA

PostPosted: Sat Jan 26, 2008 5:50 am
Reply with quote

Check the option of using WITH HOLD coz sometimes while you do a fetch and process data and afterwards explicitly do a COMMIT, the cursor is closed, the next time when you try to fetch, end up with -501 error. thats why it says do an OPEN on the cursor before FETCH.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Need help to resolve a hard edit COBOL Programming 8
Search our Forums:

Back to Top