DB2 Version 10.1 for Linux, UNIX, and Windows

DBMS_DDL module

The DBMS_DDL module provides the capability to obfuscate DDL objects such as routines, triggers, views or PL/SQL packages. Obfuscation allows the deployment of SQL objects to a database without exposing the procedural logic.

The DDL statements for these objects are obfuscated both in vendor-provided install scripts as well as in the DB2 catalogs.

The schema for this module is SYSIBMADM.

The DBMS_DDL module includes the following routines.

Table 1. Built-in routines available in the DBMS_DDL module
Routine name	Description
WRAP function	Produces an obfuscated version of the DDL statement provided as argument.
CREATE_WRAPPED procedure	Deploys a DDL statement in the database in an obfuscated format.