what is the sqlcode -501
- 5 Answers
- 12255 Views
- IBM, Polaris, Zeus, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anshuman
cursor identified in fetch or close statement is not opened.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / chinmay
Must open a cursor before attemptng to fetch from it and
close it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh patnana
cursor is already opened when we are trying to open again
| Is This Answer Correct ? | 3 Yes | 3 No |
Mention the location where the output received from explain statement is stored.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
How many Buffer pools are there in DB2 and what are they?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
is it possible to get -811 error when you use cursors. why?
what is the role of the cursor in db2?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
How can record locking be achieved in those DB2 versions which do not support it?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What does the CHECK Utility do ?
What is a root page?
COBOL 
