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 to view db2 table structure?
What do you mean by rollback?
What is the role of schema in the db2 database?
How to check sequence on a table in db2?
What is a bind in db2?
What is buffer pool in the db2 database?
What is dbrm in db2 database?
What types of tables are there in the db2 database?
What is the maximum No of rows per page?
What are foreign keys in db2?
How is the value function used?
What language is db2 written in?
What is innodb buffer pool?
What does a deadlock mean in DB2?
What are db2 objects?