Interested to Buy Any Domain ? << Click Here >> for more details...
What are PACKAGES ?
- 3 Answers
- 8878 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul nittala
The concept of packages came from this particular problem
which was faced earlier:
when there were no packages, all the dbrms for a respective
program have to be bound directly to the plan. In such
cases, whenever there was any change made to any calling or
called program within the plan, all the modules had to be
bound to their individual dbrm and then all the dbrms had
to be bound to the plan. To avoid this, the concept of
package was introduced which was just an address location
in the memory and not a physical entity. By introducing the
package concept, it was not necessary to bind all the
individual dbrms again, only that module to which change
was done had to be bound to that respective package. There
will be a one - to - one relation between a dbrm and a
package. A package actually stores the address of the dbrm.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / s
Packages are single bound DBRM. When there is an change
made to the application pgm, it requires only the bind of
the package as opposed to binding the whole plan if the
DBRM was directly bound to the plan.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / deepak dada
packages is which contains the optimised path for
accessing the db2 packages cannt be executed by itself it
can be executed when is cotained in plan
| Is This Answer Correct ? | 2 Yes | 1 No |
How do you run JCL in cobol program
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
How to resolve -805 error in DB2?
Can SQL statements/queries be included in a copybook?
What is copy pending status in db2?
What does db2 plan contain?
How to check table size in db2 sap?
What are the levels of isolation available with DB2V4
What is a plan and package in db2?
What is a DB2 access path?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
COBOL 
