CREATE AUXILIARY TABLE statement

The CREATE AUXILIARY TABLE statement defines a new auxiliary table to the Db2 system.

GUID-5C4C4E6C-DFDC-4D7D-B940-332006792AE8-low.png

CREATE AUXILIARY TABLE tableOwner 1 .tableName 1

This option specifies the fully qualified name of the auxiliary table to be created.

DATABASE databaseName

This option specifies the database for the auxiliary table.

TABLESPACE tableSpaceName

This option specifies the table space for the auxiliary table.

COMMENT 'string'

This option defines a comment for the auxiliary table.

LABEL 'string'

This option defines a label for the auxiliary table.

REFERENCETB tableOwner 2 .tableName 2

This option specifies the base table.

REFERENCECOL columnName

This option specifies the large object (LOB) column in the base table.

PART number

This option indicates the partition number to which the auxiliary table points in the base table space. If the table space is not partitioned, then PART 0.


Related topic

CDL-statements


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*