how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 11361 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 is image copy in db2?
Is there any advantage to denormalizing DB2 tables?
How does DB2 store NULL physically?
What are host variables in db2?
pls tell me abt the normalization five types....
Why use RUNSTAT Utility?
Compare a subselect to a join?
what are bind concepts in db2 cobol?
What are common abends
What is the function of buffer manager?
Is ibm db2 free?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
COBOL 
