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.

Answer / vas

Use Cursor...

Answer / alonso

How use cursor for fix it?
Never see it sorry

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

what is parm utility

2 Answers   IBM,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What is reorg?

0 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

What is cursor stability?

1 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---