Answer / s

Yes denormalization is done performance reasons.
Normalization will keep the related data in separate
tables. In order to get the data from the tables, DB2 uses
JOIN which could be resource intensive depending on the
number of tables used in the join and the size of the table.

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 rebind in db2?

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

What is meant by index cardinality?

2 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What is the use of value function?

0 Answers  

---

What is a host variable?

3 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is explain in db2?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---