What is isolation level?

4 Answers  

---

What is correlation names?

1 Answers  

---

What is meant by union and union all?

0 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

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  

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

What is image copy?

1 Answers   Virtusa,

---

What are the benefits of using the db2 database?

0 Answers  

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---