Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using a PACKAGE?
- 2 Answers
- 20910 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 |
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Why db2 is called db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is database manager in db2?
What is lock escalation?
Discuss about db2 bind?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
Can you access the DB2 Directory table using SQL?
what is parm utility
How do I add a column to an existing table in db2?
What is a recovery log?
What is the difference between IN subselects and EXISTS subselect?
COBOL 
