Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74239 Views
- Accenture, CTS, TCS, I also Faced
- E-Mail Answers
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 the use of COMMAREA ?Minimum how much data we can pass from it?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Which catalog tables contain authorization information?
how can u nderstand the sql stmts executed successfully or not ?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
what is sql abend code -801,-802?
How can record locking be achieved in those DB2 versions which do not support it?
how do we solve soc 7 and soc4 ?
What is a page?
Give a brief description of db2 isolation levels?
What is runstats utility in db2?
COBOL 
