how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 11747 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sesha
-811 results when
1)Execution of an embedded SELECT statement has resulted in
a result table containing more than one row.
2)Alternatively, a subquery contained in a basic predicate
has produced more than one value.
Solution is:
Examine the syntax of the statement to ensure that it
contains the proper condition specifications. If it does,
there may be a problem with the data that is causing more
than one row or value to be returned when you do not expect
it.
You can use cursor to overcome this problem.
| Is This Answer Correct ? | 6 Yes | 0 No |
What are the Isolation levels possible ?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Is the primary key a clustered index?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is precompiler in db2?
What happens to the PLAN if index used by it is dropped?
what is sql abend code -801,-802?
what is the input to PLAN? what is the input to DBRM?
how can we retrieve the 100 records of the file ?
COBOL 
