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 meant by index cardinality?

2 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What is buffer pool in the db2 database?

1 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

What is a host variable?

3 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

How is the value function used?

1 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---