Package storage and maintenance

You can create packages by precompiling and binding an application program. The package contains an optimized access plan that oversees the execution of all of the SQL statements found within the application.

The three types of privileges that deal with packages are the CONTROL, EXECUTE, and BIND privilege and they are used to filter the level of access acceptable. Multiple versions of the same package can be created by specifying the VERSION option at compile time. This option helps prevent the mismatched timestamp error and allows for multiple versions of the application to run simultaneously.