What is sqlcode -811?

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


Please Help Members By Posting Answers For Below Questions

What is meant by explain?

718


What is ibm db2 used for?

667


How do I delete a column in db2?

733


What is alias in db2?

643


Explain what are the various isolation levels possible?

656






What is a cursor in programming?

672


How do you select a row using indexes in db2?

720


How to find the number of rows in db2 tables?

672


What is null value in db2?

633


What is load replace in db2?

621


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?

2123


What is the default page size of buffer pools?

711


How would the varchar column remarks defined?

701


How can we read records for specific member in CL? AND rpg?

302


What is a db2 table?

659