Answer / sunil1405

database rquest module(DBRM) , they are created after the
precompilation is performed. It contains executable host
SQL statements.

Plan is the output of bind process, of which the inout to
bind is DBRM. Plan contains host SQL statements.

Answer / mehdee

The above answer is right, but the 2nd part should change
to: PLAN is an executable module containing the access path
logic to one or more DBRMs and packages.

Answer / kundan kumar

DBRM :-database request module(DBRM) , they are created after the
pre-compilation is performed. It contains parsed SQL statements.
PLAN :- PLAN is an executable module containing the access path
logic to one or more DBRMs and packages created after bind process .

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

what is a collection?

2 Answers  

---

What is dbrm library?

0 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

What is the use of value function?

0 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What are the various data types available in db2?

0 Answers  

---

What is dbrm in db2 database?

0 Answers  

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What is ibm db2 database?

0 Answers  

---