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 |
What techniques are used to retrieve data from more than one table in a single SQL statement?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
Mention data types used in db2 ?
What are the contents of dclgen?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What do you mean by storage group (stogroup)?
What is dbrm? What it contains?
What is the connection string to connect to the DB2 Database ?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?