Previous Topic: Database Definition Using DB2Next Topic: Set DDL Options for a DB2 Database


Set Table List Options

The Table List panel expands the table space and allows you to select options to generate DDL and JCL for the table, and for the table and all its subordinate indexes and index spaces.

The Table List panel supports these action codes:

G

Type G as the action code next to a table name to open the JCL Job Statement Information Input panel.

A

Type A as the action code next to a table name to open the DDL Options panel to generate DDL and JCL for the table.

E

Type E as the action code next to an object to open the Index List panel to expand the index spaces.

The Index List panel supports G as an action code. Type G next to an Index or Index Space to open the DDL Options panel to generate DDL and JCL for the index.

More information:

JCL Job Statement Information Input

Set DDL Options for a DB2 Database