What is the difference between a package and a plan?
Answer Posted / deepak dada
plan contain the package. plan is executable unit. not
package package contains only one dbrm as input and plan
contains nos of dbrm as input .package is more useful than
plan
Is This Answer Correct ? | 39 Yes | 3 No |
Post New Answer View All Answers
can all users have the privilage to use the sql statement select * (dml)?
How do I add a column in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is page size in db2?
What does db2 blu stand for?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is a Foreign Key?
Which command is used to remove all rows from a table?
What is db2? Explain.
How do I delete a table in database?
How to access db2 tables in mainframe?
What is dclgen (declaration generator)?
What is the role of schema in the db2 database?
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain the function of data manager.