Describe the elements of the SELECT query syntax?

3 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  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

What is a root page?

1 Answers  

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

What db2 400?

0 Answers  

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---