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 |
Describe what a storage group(STOGROUP) is?
what is sql abend code -801,-802?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is db2 plan table?
Can we delete records from view?
What is a lock?
what is a plan and how do you refer the plan in the program?
What does the RUNSTATS Utility do?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
Give the name of some fields form sqlca.
What is performance tuning db2?