Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using a PACKAGE?
- 2 Answers
- 20776 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Where are plans stored?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How to access db2 tables in mainframe?
can any one expalin check point with an example?
What is IMAGECOPY ?
difference between group clause and order clause
What is correlated subquery?
What is ALTER ?
how to resolve -811 error. give clear explination
Where could you look if you had a question about whether a column has been defined as an index?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What is referential integrity?
COBOL 
