how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12077 Views
- IBM, I also Faced
- E-Mail Answers
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 to fetch the last row from the table in SQL (db2)?
What r the comman abends in db2, jcl and cobol???????
What is the maximum number of columns in a db2 table?
What is the maximum No of rows per page?
What is coalesce in db2?
How can we read records for specific member in CL? AND rpg?
Are view updateable?
Is db2 a mainframe?
What is database reorganization?
How to find schema of a table in db2?
Which isolation level provides highest data integrity?
What is a collection in db2?
Before you give the explain statement, what are the prerogatives?
Which isolation level provides maximum concurrency?
What is the default page size of buffer pools?
