What is dpf in db2?

0 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

Which component is responsible for db2 startup and shutdown?

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  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is a bind in db2?

0 Answers  

---

What information is used as input to the bind process?

2 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

Which transaction use a command thread ?

1 Answers  

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---