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.

What is load utility in db2?

1174

---

How to take backup of table in db2?

1065

---

On which levels locks can be applied?

1117

---

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?

2379

---

What is the role of data manager in the db2 database?

1095

---

What is sqlca?

1055

---

What is explain in db2?

1007

---

What is scrollable cursor in db2?

1047

---

What's The Error Code For Unique Index Voilation?

1218

---

What is the information associated with sysibm.syslinks table?

1116

---

How do you find the maximum value in a column in db2?

1093

---

Name the lockable units in DB2?

1120

---

Is db2 relational database?

969

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1179

---

What are the various data types available in db2?

1078

---