What is the logical entity between plan and Package?
Answer Posted / sridhar reddy
When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is universal database?
What is the latest version of ibm db2?
Define check constraint.
What is precompiler in db2?
What are the contents of dclgen?
List down the data types in the db2 database.
How to check sequence on a table in db2?
What is the maximum No of rows per page?
What is the use of reorg in db2?
What is load utility in db2?
What does db2 blu stand for?
What is page size in db2?
How can you count the number of rows from a table tab?