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 precompiler in db2?

581


What is cursor stability in db2?

801


What is the maximum size of a char data type in db2?

582


What is the maximum size of varchar data type in db2?

640


Which components manage deadlocks in db2?

602






Are views updateable?

638


what is utility for parm lib

1868


How to view db2 table structure?

581


Is db2 a mainframe database?

559


what is db2 restart?

1684


What is host variable in db2 cobol?

593


Define data page.

626


What is db2 look?

567


Mention the downsides of page level lock.

701


What is the connection string to connect to the DB2 Database ?

610