how to resolve -811 sqlcode .give clear explaination
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 |
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What can the Locate option of the Repair Utility accomplish?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is package in cobol db2?
what is the use of cursors?
What are the functions of Bind?
what is the difference between declaring the cursor in WS section and Procedure division?
How to insert more than one record using insert?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
Mention data types used in db2 ?
What is QUIESCE?
What is the syntax required for the creation of a cursor?