What is the difference between static and dynamic SQL?

1 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

How would one remove old reorg information from the DB2 catalog?

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 sqlca?

0 Answers  

---

What is meant by union and union all?

0 Answers  

---

What is node in db2?

0 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

What is a trigger in the db2 database?

0 Answers  

---