What is sqlcode -811?
Answers were Sorted based on User's Feedback
Answer / jdriley
Is the SQLCODE returned when your singleton select
statement returns/retrieves more than one row of data.
| Is This Answer Correct ? | 68 Yes | 7 No |
Answer / kshitij
Without the use of cursor fetching two or more rows.
| Is This Answer Correct ? | 52 Yes | 6 No |
Answer / rami reddy
If single select returns more than one row then you get
SQLCODE = -811
| Is This Answer Correct ? | 38 Yes | 3 No |
Answer / 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 |
Answer / marek
The one correct answer is: "Look at DB2 doc." Who remember
all sql error codes?
| Is This Answer Correct ? | 19 Yes | 40 No |
What is query for your birthday date should be in hours,minute and seconds format?
how can i pull up a query which was previously stored in qmf
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How to check sequence on a table in db2?
What are the functions in DB2?
What is a clustered index?
What is the difference between spufi and qmf?
Update command
What is explain plan in db2?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is a root page?
What are the different types of base tables?