What is a trigger in the db2 database?

0 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

What is QUIESCE?

2 Answers  

---

What is null value in 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 buffer pool in the db2 database?

0 Answers  

---

What is bind package and plan in db2?

0 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

What is REORG? When is it used?

4 Answers  

---

What is lock escalation?

2 Answers  

---

What is meant by a unit of recovery?

1 Answers  

---

What is referential integrity?

5 Answers  

---