Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12768 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 |
Explain the EXPLAIN statement?
When do you specify the isolation level? How?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is db2 bind?
How does the processing of a correlated subquery differ from a non correlated subquery?
How to execute stored procedure in db2 command editor?
What is difference between isnull and coalesce?
What are union and union all?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is check constraint. Explain with example.
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
COBOL 
