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 to design maps

1 Answers   Virtusa,

---

What is the picture clause of the null indicator variable?

6 Answers  

---

What is a db2 tablespace?

0 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

---

Explain what a plan is?

3 Answers   CTS,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is isolation level in db2?

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

What is dbrm? What it contains? When it will be created?

0 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---