What is sqlcode -811?
- 7 Answers
- 71317 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 |
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What technique is used to retrieve data from more than one table in a single SQL statement?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is QUIESCE?
What is the purpose of using commit?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is the reason behind not using select * in embedded sql programs?
What is the database descriptor?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What does reorg do in db2?
Define buffer pool.
COBOL 
