SQL Suffixes

Use these options to create and assign suffixes to SQL statements that create indexes and tables. (These SQL statements are created by the generate command.) By adding suffixes, you can add more SQL command specifications to the end of these SQL statements. You can reference these suffixes in the Relational Properties view of the Client Configurator.

Suffixes can be up to 256 characters in length. Configuration file parameters are included in parentheses.

Create table SQL statement suffix

Default suffix (global_table_suffix)

Allows you to specify a tablespace or other SQL command specification to all of the create table SQL statements that the Client generates, except for statements associated with a specific suffix.

Suffix

Specify extra attributes for the create table SQL statements that the Client generates for any given table.

From the menu, assign a number so that you can reference it. Individual tables can select one of the suffixes by specifying this value in the create_suffix column of the corresponding DATATABLES client control table entry. The table suffix is then concatenated to all create table SQL statements for tables that specify this number.

Create index SQL statement suffix

Default suffix (global_index_suffix)

Allows you to add a tablespace or SQL command specification to all create index SQL statements that the Client generates, except for statements associated with a specific suffix. When you use a global suffix for an index, the Index value is zero (0) in the Properties view.

Suffix

Specify extra attributes for the create index SQL statements that the Client generates for any given table.

From the menu, assign a number so that you can reference the attribute. Individual indexes can select your defined attributes by specifying this number in the index_suffix column of the corresponding DATATABLES client control table entry. The index suffix is then concatenated to all create index SQL statements for this table.