what is the input to PLAN?
what is the input to DBRM?
- 4 Answers
- 9952 Views
- I also Faced
- E-Mail Answers
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 are packages in db2?
What is ibm db2 connect?
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.
How is a typical db2 batch pgm executed?
What is dbrm? What it contains? When it will be created?
how can you access index
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
On the create tablespace, what does the CLOSE parameter do?
What is a db2 collection?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
How is a typical DB2 batch program executed ?
COBOL 
