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 is deadlock resolved?

0 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

---

What are the three lock types?

2 Answers  

---

what is a collection?

2 Answers  

---

How do you retrieve the data from a nullable column?

2 Answers  

---

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

1 Answers   CTS,

---

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

1 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---