Answer / s

Data Manager evaulates the Stage 1 Predicates on the data
in the bufferpool. It also interfaces with the index
manager for index processing. Data Manager does tablespace
scans. The DM passes the qualifying rows are one column at
a time the Relational data manager.

Answer / renu gupta

Data Manager manages the physical databases by performing
all the normal access method functions

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  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

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

0 Answers  

---

What does reorg do in db2?

0 Answers  

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

Which transaction use a command thread ?

1 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

What is the difference between plan and package in db2?

0 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

What is meant by union and union all?

0 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

What is the use of commit in db2?

0 Answers  

---