Answer Posted / s
Packages are single bound DBRMs which contains SQL
statements of a single application program or subroutine.
Before the application program can be executed, you need to
bind a plan. The plan can be bound with DBRM members and/or
Package list. Without the use of packages, if there is any
change made to the program, even if there are no changes to
the SQL, the whole plan need to bound which cause
unavailabilty of the plan and it is resource intensive
since all the unrelated DBRMs are also need to be bound.
With the use of packages, only the package need to be bound
without the need to bind the plan. Also bind parameters can
be specified at package level rather than plan level
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is the latest version of ibm db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
