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 a buffer in memory?

776


How do I start db2 in windows?

779


What is deadlock in db2?

785


How to check last update on table in db2?

799


What is plan in cobol db2?

768






How to find the number of rows in a db2 table?

829


How do I optimize a query in db2?

803


Explain about open switch business continuity software?

802


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

851


What is a bind in db2?

752


Explain the contention situations caused by locks?

776


How do I add a column in db2?

760


Which isolation level provides highest data integrity?

796


Can we insert update delete in view?

734


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2955