how to resolve -811 error. give clear explination
- 4 Answers
- 8153 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 meaning of -805 SQL return code?
How to fetch the last row from the table in SQL (db2)?
What is runstats db2?
What is the self-referencing constraint?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the syntax for creating a table in the db2 database?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is buffer pool in the db2 database?
What is auditing?
How to select the duplicate rows from a table?
what is the difference between where clause and having clause
COBOL 
