Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12922 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 |
Which component is responsible for processing sql statements and selecting access paths?
i have a db2 variable how do u declare tht into working storage section ?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
Can we install 2 different versions of Db2 on same mainframe?
How to create backup table in db2?
What are the two types of logging in the db2 database? Explain them.
How do you filter out the rows retrieved from a Db2 table ?
What is bind plan?
what is the use of cursors?
Where is the access path logic created by the DB2 Optimizer stored?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is collection in db2 bind?
COBOL 
