One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
Answer Posted / 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 |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is db2 bind process?
How to rename a table in DB2 ?
What is difference between alias and synonym in db2?
What is the difference between plan and package in db2?
When reorg is used?
i want to maintain uniqueness on pdf without make lf??????????
What is runstats db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to test SQL -911 error while developing COB-DB2 program
What is nvl in db2?
What is the use of runstats in db2?
How do I add a column in db2?
Explain the contention situations caused by locks?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?