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 do you mean by cursor?

801


What are the contents of dclgen?

878


What is rct?

1011


Discuss about db2 bind?

892


What is the physical storage length of date data type?

1020


Is db2 a database?

767


How to resolve deadlock issue

19093


What is clone table?

815


How can deadlocks be resolved?

751


What is netezza database?

797


What is db2 stogroup?

916


How would you find out the total number of rows in a db2 table?

809


What is runstats utility in db2?

783


Which component is responsible for processing sql statements and selecting access paths?

913


How to fetch the last row from the table in SQL (db2)?

1345