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 |
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
what is a plan and how do you refer the plan in the program?
How Plan is created while executing the query using SPUFI?
how to execute qcmdexc in rpgle?plz write code also?
How do I delete a column in db2?
What is cursor with hold option in db2?
What is a DB2 catalog?
what is different three logs in DB2?
is it compulsory commitment control in journal?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Define sqlca.
how will you retrieve first record in table