Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are the advantages of using a PACKAGE?

Answers were Sorted based on User's Feedback



What are the advantages of using a PACKAGE?..

Answer / 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

What are the advantages of using a PACKAGE?..

Answer / guest

First u need to know the concept precompliation and
compliation process of db2 cobol program...

the maina dvange of pakage is, supose u have cobol db2
program, this prgoram is using 4 sub programs. if any one
of the sub programs undergoes changes u need to precompile
the main program. this can avoided by using the pakage
concept.

so u need to create one pakage for on sub program. if any
sub programs undergoes any change, u need to compile only
sub program.

Filnally one program will have one pakage and one DBRM lib.

Is This Answer Correct ?    9 Yes 6 No

Post New Answer

More DB2 Interview Questions

What is rebind in db2?

0 Answers  


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


What is the purpose of the QUIESE Utility?

1 Answers  


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


What does db2 mean?

0 Answers  


List out the buffer pools in db2

0 Answers  


What is meant by the attachment facility?

3 Answers  


What are the levels of isolation available with DB2V4

2 Answers   IBM,


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What is correlation names?

1 Answers  


What is syscat in db2?

0 Answers  


Categories