what is the sqlcode -501
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 |
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What are host variables in db2?
What is the SQL Communications Area and what are some of its key fields?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the reason behind not using select * in embedded sql programs?
What is a cursor?
B37 abend during spufi?
how do you resolve -805?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is the use of predicate?
What are column-name qualifiers used?
How does DB2 determine what lock-size to use?