Customizing - 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 Scripts 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 page of the Customize command.
Suffixes can be up to 256 characters in length. Configuration file parameters are included below with the following_font.
Table SQL Statement suffix
Default suffix (192 characters or less)
Parameter: global_table_suffix
This option enables you to add a filegroup (SQL Server), tablespace (Oracle), 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).
Index (1 to 100) Suffix
Parameter: create_table_suffix[n]
This option allows you to add a filegroup (SQL Server), tablespace (Oracle), or other SQL command specification
for specific tables. This option sets the create_suffix column in the DATATABLES Client control table to the value n,
which references the configuration create_table_suffix parameter with index n.
If using the Customize command, navigate to the Relational page for the data set and update the data table's properties by picking the desired suffix from the Create table SQL Suffix list box. For more information on user scripts, consult the Databridge Client Administrator's Guide.
Index SQL Statement suffix
Default suffix (192 characters or less)
Parameter: global_index_suffix
This option allows you to add a filegroup (SQL Server), tablespace (Oracle), or other SQL command specification to
all of the create index SQL statements that the Client generates (except for statements associated with a specific suffix).
Index (1 to 100) Suffix
Parameter: create_index_suffix[n]
This option allows you to add a filegroup (SQL Server), tablespace (Oracle), or other SQL command specification
for specific tables. This option sets the index_suffix column in the DATATABLES Client control table to the value n,
which references the configuration create_index_suffix parameter with index n.
If using the Customize command, navigate to the Relational page for the data set and update the data table's properties by picking the desired suffix from the Create index SQL Suffix list box. For more information on user scripts, consult the Databridge Client Administrator's Guide.
Data masks
This section is only applicable to SQL Server Clients.
Index (1 to 100) Suffix
Parameter: masking_parameter[n]
(SQL Server only) Allows you to define the various parameter strings for the random and partial data masking functions.
If using the Customize command, navigate to the Relational page for the data set and update the desired data item to apply data masking on the data item properties page. After the masking function is selected, pick the desired masking parameter string from the Masking Parameters list box. For more information on user scripts, consult the Databridge Client Administrator's Guide.