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
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is cloudant database?
What are db2 tables?
What is a db2 schema?
Explain the function done by data manager?
What is db2 look?
Outputs of explain are with matchcols = 0. What does this signify?
Explain what are the various isolation levels possible?
How to check table size in db2 sap?
How to find the maximum value in a column in the db2 database?
is it compulsory commitment control in journal?
What is meant by dclgen?
What are the various isolation levels possible?
How to retrieve rows from a db2 table in embedded sql?