What is a DBRM, PLAN ?
Answers were Sorted based on User's Feedback
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 |
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 |
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is the usage of open cursor command?
Can we use select * statement in cobol program without giving field names ???
what types of copies can be made with the COPY Utility ?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What are the bind parameters ibm db2?
What will the FREE command do to a plan?
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 ?
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.
Is db2 relational database?
Give the name of some fields form sqlca.