Updating Client Control Tables

Some values in the client control tables can be updated. For best results, use the Client Configurator to customize the table layout for the relational database instead of directly editing the control tables.

Note: If you previously used user scripts to update control tables and want to switch to the Client Configurator, you'll need to update your client control tables first. For instructions, see the Next Steps section in the DATABridge Installation Guide.

Edit these values

To do this

Values in the active column

Set cloning on or off for data sets or DMS items.

Values in the dms_subtype column

Specify the format of a field that is to be cloned as a date.

Relational database table and column names

Rename tables and columns.

The set_name column in the DATASETS table and the item_key columns in the DMS_ITEMS table

Create a composite key.

The options column in the DATASETS, DMS_ITEMS, DATATABLES and DATAITEMS tables

Set a value.

The sql_type, sql_length and sql_scale columns in the DATAITEMS table

Force the define command to remap values.

The dms_concat_num column in the DMS_ITEMS table

Set the value of the dms_item_number you want concatenated to this item.

The table_name and index_name columns in the DATATABLES table