What is package versioning? Please give an example.
- 1 Answers
- 4047 Views
- I also Faced
- E-Mail Answers
Answer / mani
Versioning allows multiple packages that share both the
schema and Package ID to co exist in the system catalogs.
A sample application called payroll is compiled from
payroll.sqc.This application would be precompiled and the
package payroll bound to the database and the application
delivered to the users.users then could run the application
in production.
If the application required modification (even without sql
changes) the process of recompiling,binding and sending the
application to the users must be repeated.If the version
option was not specified for this second precompilation of
payroll, the first package is replaced by second package.
Any user who attempts to run the old version of application
would get -818 error.To avoid this use VERSION and it allows
both versions of the appliction to run at the same time.
When the first version of Payroll was created, the version
option should be used during the precompilation step.
DB2 PREP PAYROLL.SQC VERSION V1.1
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the SQL Communications Area and what are some of its key fields?
What action db2 takes when a program aborts in the middle of a transaction?
What is an alias?
Can you use max on a char column?
How would one remove old reorg information from the DB2 catalog?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is difference between rollback and commit?
When would you prefer to use VARCHAR?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What is precompiler in db2?
What is a storage group (stogroup)?
COBOL 
