Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What are host variables in db2?

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What is data manager?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What is an access path?

3 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

What is dbrm? When it will be created?

0 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

Define db2.

0 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 is explain in db2?

0 Answers  

---