how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 11317 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 |
What is null indicator in cobol db2?
What do you mean by cursor?
How will fetch last 5 rows from table in db2
Give some example of statistics collected during RUNSTATS?
How to resolve -803 sql code in DB2?
What is the use of predicate?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is innodb buffer pool?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Explain about dbrm.
Where can you declare a cursor in a cobol-db2 program?
COBOL 
