how to resolve -811 sqlcode .give clear explaination
- 3 Answers
- 12056 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 |
In terms of DB2 indexing, what is the root page?
What is an access path?
What is QUIESCE?
What is reorg in database?
What is isolation level in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is role in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
what is SMP/E? and what are the major steps of it? thanks...
What is bind and rebind in db2?
What is DCLGEN?
COBOL 
