Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12734 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 |
Compare a subselect to a join?
What is the purpose of the QUIESE Utility?
What is DCLGEN ?
What is package in cobol db2?
What is difference between rollback and commit?
What is an alias?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
How can you quickly find out the number of rows updated after an update statement?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Write a query to retrive partial string.
What are the three DB2 date and time data types and their associated functions?
How and when does the db2 enforces the unique key?
COBOL 
