Where is the output of EXPLAIN stored?

2 Answers  

---

How do I import a csv file into db2?

0 Answers  

---

Are views updatable ?

4 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

What are PACKAGES ?

3 Answers  

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is an alias?

3 Answers  

---

Mention the definition of cobol in varchar field.

0 Answers  

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

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  

---