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 do I import a csv file into db2?

0 Answers  

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

What is the use of commit in db2?

0 Answers  

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---

What is sqlca?

0 Answers  

---

What is runstats and reorg in db2?

0 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is normalization and what are the five normal forms?

1 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---