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 |
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
how to copy the host variables from ps file into cobol program other than include statement
What is ACQUIRE/RELEASE in BIND?
How to handle null values in db2
Explain the contention situations caused by locks?
What is JOIN and different types of JOIN.
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
How to find the number of rows in db2 tables?
Outputs of explain are with matchcols = 0. What does this signify?
What are iseries servers?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected