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 .

Compare a subselect to a join?

1 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

what is the difference between join and union?

4 Answers   IBM,

---

What is the usage of open cursor command?

0 Answers  

---

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

0 Answers   MCN Solutions,

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

Is ibm db2 open source?

0 Answers  

---