what is the use of the VERSIONID in the case of the DB2....
generally we will be specifying the VERSION ID while we r using the EXPLAIN statement in the PACKAGE.....what is the advantage of having the VERSIONID.
Joined: 28 Jan 2004 Posts: 37 Location: Trivandrum
I am noting certain details about Version ID.
Multiple versions of the same package can be supported in a single system by using the new version option for packages.
The intent of this option is to allow multiple packages that share both the schema and package-id to co-exist in the system catalogs. This option will allow you to introduce and test a new version of a package on the system without affecting users of the existing version of the package. The support of the version option will allow ongoing package maintenance to occur without interruption of end-user access to the system.
The PREP, BIND, REBIND and DROP PACKAGE facilities have been enhanced to support package versioning.