Interested to Buy Any Domain ? << Click Here >> for more details...
What is package versioning? Please give an example.
- 1 Answers
- 4795 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 |
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?
What will the DB2 optimizer do?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is the advantage in De-normalizing tables in DB2?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
i want to maintain uniqueness on pdf without make lf??????????
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
How to check table size in db2 sap?
What is a composite index and how does it differ from a multiple index?
What is the difference between cursor stability and repeatable read isolation levels?
How do I add a column in db2?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
COBOL 
