Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is a DBRM, PLAN ?

Answers were Sorted based on User's Feedback



What is a DBRM, PLAN ?..

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.

Is This Answer Correct ?    16 Yes 3 No

What is a DBRM, PLAN ?..

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.

Is This Answer Correct ?    13 Yes 2 No

What is a DBRM, PLAN ?..

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 .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


What is the usage of open cursor command?

0 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


what types of copies can be made with the COPY Utility ?

1 Answers  


how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


What are the bind parameters ibm db2?

0 Answers  


What will the FREE command do to a plan?

2 Answers  


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,


Is db2 relational database?

0 Answers  


Give the name of some fields form sqlca.

0 Answers  


Categories