DB2 Version 10.1 for Linux, UNIX, and Windows

STATICASDYNAMIC string for the GENERIC option on the BIND command

You can set the DB2® database manager to store all statements in the catalogs and marks them as incremental bind. To achieve this setting, the STATICASDYNAMIC YES string must be set for the GENERIC BIND command option.

At run time, when the package is first loaded, the database manager uses the current session environment (rather than the package) to set up the section entries and other entities (text is populated and the package cache is accessed).

Thereafter, the statements in the bound file behave the same as they would if you were using dynamic SQL. For example, sections are implicitly recompiled for database definition language invalidations, special register updates. The new syntax is defined as follows:

DB2 BIND filename GENERIC 'STATICASDYNAMIC [YES|NO]'