Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 error. give clear explination
- 4 Answers
- 9307 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 |
How to find last record before record through SQLRPGLE?
What is the use of dclgen in db2?
How do I delete a table in db2?
What is JOIN and different types of JOIN.
How to resolve -407 sql code in DB2?
When is the authorization check on DB2 objects done - at BIND time or run time?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is clone table?
List some fields from sqlca?
Explain what a plan is?
What are the two types of logging in the db2 database? Explain them.
What is db2 isolation?
COBOL 
