What is a DBRM, PLAN ?
- 3 Answers
- 17399 Views
- I also Faced
- E-Mail Answers
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 |
Which component is responsible for processing sql statements and selecting access paths?
How does the processing of a correlated subquery differ from a non correlated subquery?
wht r the requirements for writing a cobol-db2 pgm ?
What is meant by isolation level?
What does the sqlcode of -818 pertain to?
what are bind concepts in db2 cobol?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is a db2 package?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
can any body explain about plan and pakage in detail....
COBOL 
