Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 13074 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 |
Can a Db2 table data be retrived through JCL?
what is + sign and -ve sign for sql code ?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What are the disadvantages of PAGE level lock?
What does db2 stand for?
How do I import data from excel to db2?
What do you mean by storage group (stogroup)?
What is data manager?
What is sqlca?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
How to find primary key of a table in db2?
how to fetch multiple records without using cursor
COBOL 
