Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12953 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is temporal table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is phantom read in db2?
What does runstats do in db2?
What db2 400?
How does cobol compile db2 program?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Highlight all the advantages that are attached to a package.
What is the usage of open cursor command?
What is db2 optimizer?
How do I change the column size in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can you count the number of rows from a table tab?
How do I connect my db2 database to ibm?
Is db2 a mainframe?
