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

Define data page.

712


Why select is not preferred in embedded sql programs?

815


What is the maximum number of columns in a db2 table?

828


How do I optimize a query in db2?

710


What are types of indexes?

675






How to find the maximum value in a column in the db2 database?

685


How to find primary key of a table in db2?

713


What is temporal table in db2?

686


What is null in db2?

652


What are bind parameters in db2?

689


If I have a view which is a join of two or more tables, can this view be updateable?

795


What is a bind card?

770


What is copy pending status in db2?

734


What is reorg and runstats in db2?

793


What is a Foreign Key?

744