Interested to Buy Any Domain ? << Click Here >> for more details...
One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 18500 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
when u precompile a Db2 program you will get (n+1) DBRMs
where n indicates no. of subprograms. So in our case you
will get 6 DBRMs. Through Binding process you can get
minimum of 1 package and maximum of 6 packages. But finally
you will get only one plan.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / vat
Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.
You would have to do bind to even talk about packages/plans.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / snehasis
If it generate 6 DBRM, then there is no possibility to have
1 package. The reason is one package can contain only one
DBRM. But yes for all these DBRM and Packages it will be
only one plan.
| Is This Answer Correct ? | 9 Yes | 3 No |
what is utility for parm lib
How does cobol compile db2 program?
What is explain plan in db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What do the initials DDL and DML stand for and what is their meaning?
What is the use of db2 optimizer?
Which component is responsible for processing sql statements and selecting access paths?
How to compare data between two tables in db2?
Write a query to retrive partial string.
What is the use of db2?
What are the bind parameters ibm db2?
How can we define a table? How can we apply SEARCH ALL on it ?
COBOL 
