Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 error. give clear explination
- 4 Answers
- 9355 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 is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
how to resolve -805 . how to see dbrm and package not found
how to resolve -811 sqlcode .give clear explaination
how to fetch first 100 rows in db2
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is bind in db2?
what is the Foreign key? explain?
What is a clustered index?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is the error code -803 ?
What is dbrm? When it will be created?
Is db2 relational database?
COBOL 
