Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74163 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 lock contention?
What is the database descriptor?
How to rename a table in DB2 ?
Which component is responsible for processing sql statements and selecting access paths?
What are the benefits of using the db2 database?
What db2 400?
what is the difference between join and union?
How to define the a field which accepts value till 99999.99 in db2
How to execute stored procedures?
What is database reorganization?
how to u check the query is executing or not ?where will u check for sqlcode ?
Give a brief description of db2 isolation levels?
COBOL 
