Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is package versioning? Please give an example.



What is package versioning? Please give an example...

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

Post New Answer

More DB2 Interview Questions

What is an intent lock?

3 Answers  


What is the purpose of rollback and commit?

0 Answers  


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,


What is CHECK PENDING ?

5 Answers  






Explain an outer join?

1 Answers  


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,


How do I connect my db2 database to ibm?

0 Answers  


Can we update view in db2?

0 Answers  


How to take backup of table in db2?

0 Answers  


I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,


What is host variable in db2 cobol?

0 Answers  






Categories