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


Please Help Members By Posting Answers For Below Questions

What is table space in db2?

589


What is cobol db2?

572


What is meant by dclgen?

623


What is db2 bind?

644


What is the cobol picture clause of the db2 data types date, time, timestamp?

625






Name the various locking levels available?

640


What is database manager in db2?

557


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1906


Which component is used to execute the sql statements?

630


On which levels locks can be applied?

667


How to view db2 table structure?

601


Can you tell me how can you find out the # of rows updated after an update statement?

618


What is ibm db2 database?

543


Mention the downsides of page level lock.

719


What is the physical storage length of date data type?

735