Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74605 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 |
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is bind and rebind in db2?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is lock escalation in db2?
On the create tablespace, what does the CLOSE parameter do?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How would the varchar column remarks defined?
What is the information associated with sysibm.syslinks table?
What are the various isolation levels possible?
What r the comman abends in db2, jcl and cobol???????
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What are the various locks available?
COBOL 
