Generating the DDL for a database

The dblook utility generates all of the following objects when generating the DDL for a database:

• Checks
• Indexes
• Jar files
• Keys (primary, foreign, and unique)
• Schemas
• Stored procedures
• Triggers
• Tables
• Views

Note:

When dblook runs against a database that has jar files installed, it will create a new directory, called CSJARS, within the current directory, and that is where it will keep copies of all of the jars it encounters. In order to run the generated DDL as a script, this CSJARS directory must either 1) exist within the directory in which it was created, or 2) be moved manually to another directory, in which case the path in the generated DDL file must be manually changed to reflect to the new location.

The dblook utility ignores any objects that have system schemas (for example, SYS, SYSIBM), since DDL is not able to directly create nor modify system objects.