Interested to Buy Any Domain ? << Click Here >> for more details...
What is package versioning? Please give an example.
- 1 Answers
- 4807 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 |
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the self-referencing constraint?
What is the default page size of buffer pools?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is a data page?
In terms of DB2 indexing, what is the root page?
Explain what are the various isolation levels possible?
can any body explain about plan and pakage in detail....
What are the levels of isolation available with DB2V4
What DB2 Catalog column tell you when an index needs table reorganized ?
max number of columns in a db2 table?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
COBOL 
