Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12958 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 tablespace?
What is the use of reorg in db2?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is difference between rollback and commit?
What is node in db2?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is a data page?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is cursor stability?
What is dpf in db2?
Is there any advantage to denormalizing DB2 tables?
COBOL 
