Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain how can you do the explain of a dynamic sql statement?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the role of the data page in the db2 database?
What is rebind in db2?
How connect db2 database to datastage?
How to find the maximum value in a column in the db2 database?
What is the result of open cursor statement?
Why do we bind in db2?
What's The Percentage Free Space ?
What do you mean by commit and rollback?
How do I optimize a query in db2?
what is the sqlcode -501
What does runstats do in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Is the primary key a clustered index?
