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 are the different types of base tables?

1027

---

What is db2 instance?

1016

---

What are the bind parameters ibm db2?

989

---

Highlight all the advantages that are attached to a package.

1072

---

What is the connection string to connect to the DB2 Database ?

1059

---

How to take backup of table in db2?

1021

---

How does db2 sample database connect?

972

---

What is db2 plan table?

992

---

Discuss about db2 bind?

1049

---

How will you return the number of records in table?

880

---

Outputs of explain are with matchcols = 0. What does this signify?

991

---

How do we specify index to include or not during bind process.

2070

---

Which component is responsible for db2 startup and shutdown?

980

---

What are the rules for db2 programming?

1041

---

What is the maximum size of a char data type in db2?

963

---