Answer / jagan

using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.

In case more than one row is retrieved in a select clause it
will throw -811 sql error.

Answer / vinay srivastava

Normal select Query fetches all rows in one go while cursor
fetches one row at a time.

What is the default page size of buffer pools?

0 Answers  

---

What is usage pointer in cobol?

3 Answers   IBM,

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

What information is used as input to the bind process?

2 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---