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  

---

List out the data types available.

0 Answers  

---

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

0 Answers  

---

What is cascading rollback?

0 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

List some fields from sqlca?

0 Answers  

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---