What is package versioning? Please give an example.
- 1 Answers
- 4935 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 |
how can we retrieve the 100 records of the file ?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a db2 tablespace?
How do you filter out the rows retrieved from a Db2 table ?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
what is the use of commit ? and what is the syntax?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
how to unload different table data into different gdg files/ vsam files.
how to get duplicate records from tables?write qurey for this?
What is concurrency?
What are the 4 environments which can access DB2 ?
COBOL 
