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 meant by explain?
What is ibm db2 used for?
How do I delete a column in db2?
What is alias in db2?
Explain what are the various isolation levels possible?
What is a cursor in programming?
How do you select a row using indexes in db2?
How to find the number of rows in db2 tables?
What is null value in db2?
What is load replace in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the default page size of buffer pools?
How would the varchar column remarks defined?
How can we read records for specific member in CL? AND rpg?
What is a db2 table?