Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12964 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 happens to the PLAN if index used by it is dropped?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is db2 catalog database?
Who uses db2?
What is cascading rollback?
Explain about cursor stability?
How to find primary key of a table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How do I connect my db2 database to ibm?
Explain various types of locks in db2?
What is a collection in db2?
Which component is used to execute the sql statements?
COBOL 
