what is the input to PLAN?
what is the input to DBRM?

Answers were Sorted based on User's Feedback



what is the input to PLAN? what is the input to DBRM?..

Answer / harish

dbrm or package is input to plan....talking abt
dbrm.......the cobol+db2 prgrm is input to precompiler which
separtes cobol souce code and dbrm

Is This Answer Correct ?    8 Yes 2 No

what is the input to PLAN? what is the input to DBRM?..

Answer / mani

DBRMs and Packages are the input to the plan as said above.
The input to DBRM is the sql statements in the cobol db2
program
i.e all the sql statements in the cobol db2 program will be
replaced by the host language statements in this case it is
cobol and the sql statements are bound into DBRMs.

Is This Answer Correct ?    2 Yes 2 No

what is the input to PLAN? what is the input to DBRM?..

Answer / guest

The input to a plan is a DBRM or package. The DBRM is a
copy of the SQL statements of the program that is being
prepared.

Is This Answer Correct ?    1 Yes 1 No

what is the input to PLAN? what is the input to DBRM?..

Answer / anil reddy

DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.

PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Explain an outer join?

1 Answers  


What are db2 objects?

0 Answers  


Where is the output of EXPLAIN stored?

2 Answers  


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,






Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


What is db2 instance?

0 Answers  


What happens in bind step in a db2 program?

0 Answers  


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


Can you Average the Characters ?

3 Answers  


I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


Categories