what is the input to PLAN?
what is the input to DBRM?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is dbrm in db2 database?
What do the initials DDL and DML stand for and what is their meaning?
why we create view.
What are types of indexes?
Can SQL statements/queries be included in a copybook?
What are the contents of dclgen?
What is a page in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
Can we use select * statement in cobol program without giving field names ???
How can you do the explain of a dynamic sql statement?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is a NULL value? What are the pros and cons of using NULLS?