Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 error. give clear explination
- 4 Answers
- 9205 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 will happen, while trying to close the closed cursor.
How to run db2 command in windows?
What is a clustering index?
how to resolve -811 sqlcode .give clear explaination
What is lock escalation?
What is bind package and plan in db2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How does coalesce work?
What are PACKAGES ?
What is a composite index and how does it differ from a multiple index?
Is db2 a mainframe?
COBOL 
