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 is the use of predicate?
what is diffrence b/w file-aid tool and file-aid utility???
What is the maximum length of sqlca?
What are types of indexes?
Explain in brief how does db2 determine what lock-size to use?
What is a collection in db2?
Highlight all the advantages that are attached to a package.
How to execute stored procedure in db2 command editor?
What is the physical storage length of date data type?
What is the result of open cursor statement?
Explain package in db2 and its advantages?
What is difference between rollback and commit?
How can record locking be achieved in those DB2 versions which do not support it?
What is the usage of open cursor command?
Which component is responsible for db2 startup and shutdown?