Interested to Buy Any Domain ? << Click Here >> for more details...
What is package versioning? Please give an example.
- 1 Answers
- 4779 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 difference between Primary key and unique index?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between using bind () and rebind () methods of naming class?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is clone table?
How can you display the current date & current time ?
Explain in brief how does db2 determine what lock-size to use?
How does the processing of a correlated subquery differ from a non correlated subquery?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is subquery ?
difference between group clause and order clause
What is a storage group (stogroup)?
COBOL 
