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
- 18619 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 |
How to execute stored procedure in db2 command editor?
How is deadlock resolved?
How will you return the number of records in table?
What is blu acceleration in db2?
wht steps we need will coding cobol and db2 pgm ?
What is a synonym ?
Which command is used to remove all rows from a table?
What is the difference between nvl and coalesce?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
what is the difference between declaring the cursor in WS section and Procedure division?
What does runstats do in db2?
How can you display the current date & current time ?
COBOL 
