IBM DB2 Question:
Download Questions PDF

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:

when u bind , 5 queries has 5 sql statements in 1 DBRM, its
regroup into 1 package, 1 plan...Plan is a collection of
packages..
correct me if i'm wrong..

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
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.
TIA		could you give me an example how, where i code CHECKPOINT
and restart. I need and example