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 |
What are the contents of a DCLGEN?
How do you run JCL in cobol program
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Which component is responsible for processing sql statements and selecting access paths?
What is ibm db2 used for?
What do you need to do before you do EXPLAIN?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is explain in db2?
What is blu acceleration in db2?
What is concurrency in db2?
What does db2 stand for?