Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 error. give clear explination
- 4 Answers
- 9534 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / u
When a Select query
or
Subselect query returns more than one row
the sqlcode -811 is returned
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinvasa yadav
RETRIEVING MORE THAN ONE ROW BY USING SELECT STATEMENT THEN
AN ABEND WILL OCCUR I.E -811.
RESOLVE: DELCARE CURSOR
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / venkat
REASON: BY USING SELECT QUERY,WE CAN ACCESS MULTIPLE ROWS THEN -811 ERROR OCCURS
SOLUTION : BY USING CURSORS, WE CAN ACCESS MULTIPLE ROWS
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / krishnaveni
-811:cursor not defined:
whenever select trying to retrieve multiple records we will
get this error
this error can be resolved when we declare a cursor
| Is This Answer Correct ? | 0 Yes | 0 No |
what's the error code for Unique Index Violation?
Explain the EXPLAIN statement?
How does one remove entries from the SCT02 table?
Explain about dbrm.
Are view updateable?
How can deadlocks be resolved?
What is REORG? When is it used?
What are the three types of page locks that can be held?
Before you give the explain statement, what are the prerogatives?
what is the use of bind parameter, Replace?
What is ibm db2 connect?
How do I change the column size in db2?
COBOL 
