If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?

Answer Posted / sampath

1 DBRM, 1 Package & 1 plan

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scrollable cursor in db2?

574


What is bind in db2?

597


What is meant by explain?

654


What is an instance database?

590


Why select is not preferred in embedded sql programs?

702






What is the default page size of buffer pools?

640


Why do we bind in db2?

615


What is db2 look?

565


How do I import a csv file into db2?

553


What is check constraint in db2?

597


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

620


How do I add a column in db2?

583


What action db2 takes when a program aborts in the middle of a transaction?

648


How would the varchar column remarks defined?

625


Define db2.

659