how to resolve -811
Answers were Sorted based on User's Feedback
Answer / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
Is This Answer Correct ? | 3 Yes | 0 No |
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What's The Percentage Free Space ?
how to resolve -811 sqlcode .give clear explaination
What is the function of the Data Manager?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
How do I delete a table in db2?
What are foreign keys in db2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Can any one tell me about Restart logic in DB2.
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
Explain in detail about buffer manager and its functionalities?
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?