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 is the physical storage length of date data type?

0 Answers  

---

What is rebind in db2?

0 Answers  

---

What is lock escalation in db2?

0 Answers  

---

What is db2 instance?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is the difference between oracle and db2?

0 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

How do you eliminate duplicate values in db2?

0 Answers  

---

What are column-name qualifiers used?

1 Answers  

---

What is runstats utility in db2?

0 Answers  

---