What is the difference between a package and a plan?

Answer Posted / s

A package is a single bound DBRM.
Many DBRMs/packages can be bound to a Plan.

Is This Answer Correct ?    31 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does reorg do in db2?

769


What is null indicator in db2?

818


What is nvl in db2?

804


Define sqlca.

836


What is explain in db2?

759


can all users have the privilage to use the sql statement select * (dml)?

828


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 ?

1898


B37 abend during spufi?

1194


What is the advantage in De-normalizing tables in DB2?

930


Why db2 is called db2?

760


What is alias in db2?

790


How many databases can be created inside an instance in db2 ?

799


How will you return the number of records in table?

692


What do you mean by between and in? Is between inclusive of specified range values?

854


How do you find the maximum value in a column in db2?

820