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	Rename.