Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 error. give clear explination
- 4 Answers
- 9396 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 |
Differentiate between cs and rr isolation levels? Where do you specify them?
select distinct(empid),distinct(dept),name from EMP will the above query work?
How to check sequence on a table in db2?
How to find the maximum value in a column in the db2 database?
What is meant by the attachment facility?
Give some example of statistics collected during RUNSTATS?
What is auditing?
How do I create a view in db2?
What is meant by repeatable read?
What does an outer join do?
What is a trigger in the db2 database?
How many databases can be created inside an instance in db2 ?
COBOL 
