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
What do you mean by cursor?
What are the contents of dclgen?
What is rct?
Discuss about db2 bind?
What is the physical storage length of date data type?
Is db2 a database?
How to resolve deadlock issue
What is clone table?
How can deadlocks be resolved?
What is netezza database?
What is db2 stogroup?
How would you find out the total number of rows in a db2 table?
What is runstats utility in db2?
Which component is responsible for processing sql statements and selecting access paths?
How to fetch the last row from the table in SQL (db2)?