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

How will you return the number of records in table?

0 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

What is drop table?

0 Answers  

---

why we create view.

5 Answers  

---

What is DCLGEN ?

2 Answers  

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

How to design maps

1 Answers   Virtusa,

---

What is scrollable cursor in db2?

0 Answers  

---

When the like statement is used?

0 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---