how to resolve -811 sqlcode .give clear explaination
Answer Posted / 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 |
Post New Answer View All Answers
How is the value function used?
What is host variable in db2 cobol?
What is rebind in db2?
What is coalesce in db2?
How to restart a DB2 program?
Why do chiropractors use drop table?
What is the physical storage length of date data type?
What is role in db2?
What is schema in db2?
Which isolation level provides maximum concurrency?
define clustering index.
What is with ur in db2?
How to access db2 tables in mainframe?
What is difference between isnull and coalesce?
What type of database is db2?