One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

653


Which is faster delete or truncate?

671


Define db2.

665


What is a collection in db2?

579


What is image copy in db2?

564






What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

704


What is the information associated with sysibm.syslinks table?

655


Before you give the explain statement, what are the prerogatives?

575


What is collection in db2 bind?

570


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

624


What is nvl in db2?

624


Mention some fields that are a part of sqlca.

597


How to create backup table in db2?

638


What is cursor stability in db2?

803


can all users have the privilage to use the sql statement select * (dml)?

637