Skip to content

Templated DDL/SQL

DDL/SQL to define or change a Db2 stored procedure, user defined function, or trigger is obtained from the staging libraries in your change package. Unlike BIND command members, DDL/SQL is never actioned from promotion or baseline libraries.

Templates defined in the logical subsystem in the Db2 Option are applied to provide DDL/ SQL that is suitable for the target Db2 environment.

You can modify many parameters in the definitions for stored procedures, triggers, and user defined functions by using both named parameter templates and general token templates (described elsewhere in this manual). The CMNDB2DD HLL exit is also available for DDL/SQL validation and manipulation.