how to resolve -811

Answers were Sorted based on User's Feedback



how to resolve -811..

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

how to resolve -811..

Answer / vamsi

use perform statement

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  


What's The Percentage Free Space ?

0 Answers   IBM,


how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,


What is the function of the Data Manager?

2 Answers  


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.

3 Answers   IBM,






How do I delete a table in db2?

0 Answers  


What are foreign keys in db2?

0 Answers  


why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


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

2 Answers  


Explain in detail about buffer manager and its functionalities?

0 Answers  


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?

4 Answers  


Categories