Answer Posted / bharani
We get error -811, when 'WHERE' criteria in singleton query
matched with multiple rows of a table, it can only fetch
and process one row at a time. Only way to avoid this error
by using cursor concepts.
| Is This Answer Correct ? | 29 Yes | 1 No |
Post New Answer View All Answers
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are the contents of dclgen?
What are the bind parameters ibm db2?
What is cursor stability in db2?
Are views updateable?
What is the picture clause of null indicator variable?
Explain in brief how does db2 determine what lock-size to use?
What is schema in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Where can you declare a cursor in a cobol-db2 program?
Explain packages.
Explain what are the various isolation levels possible?
How to find the maximum value in a column in the db2 database?
Why do we use cursor?
what is the role of the cursor in db2?