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 .

What are the contents of a dclmgen?

0 Answers  

---

Where are plans stored?

2 Answers  

---

How do I optimize a query in db2?

0 Answers  

---

How will you return the number of records in table?

0 Answers  

---

What is db2 bind process?

0 Answers  

---

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What are db2 tables?

0 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

How to design maps

1 Answers   Virtusa,

---

Can you Average the Characters ?

3 Answers  

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---