Data Table Properties
Databridge Servers > Client Managers > Settings > Customize > (click on data set) > Relational > Settings > Properties
The customizable properties for a data table are organized in the following sections:
This section has one updatable properties, Table Name.
This entry represents the value of the
table_name column in the DATATABLES Client control table for the item. You can rename a table by typing the new name in this input field. You must use a name that conforms to the database naming conventionn while also avoiding names that are reserved words in the database or that duplicate other table names in the database. When a table is renamed, all the entries in the DATAITEMS need to be changed to have the new table. This process is handled automatically by the Administrative Console to simplify the process of renaming a table.
This section has two entries Create Table SQL Suffix and Create Index SQL Suffix. The entries allow you to add optional extensions to the "create table" and "create index" SQL statements for the table. Use these entries to control how the table allocates more space when it is full, or TABLESPACE where the table is to be created (TABLESPACE in the case of Oracle and filegroup in the case of SQL Server).
The suffixes are defined in the Client configuration file using the
create_index_suffix[n] parameters. These parameters allow you to pick a string from the corresponding list and set the
index_suffix columns in the DATATABLES Client control tables to be the index of the selected string. Refer to the Configure command in the data source's Settings menu to find out more about SQL suffixes.
This section has three editable properties Use Clustered Index, Use Primary Key and User Stored Procedure.
Use Clustered Index
(SQL Server client only) This option corresponds to the
dt_options bit DTOPT_Clustered_Index in the DATATABLES Client control table, which gets its initial value from the parameter
use_clustered_index. See the Databridge Client Administrator's Guide for details on the various index types.
Use Primary Key
This option corresponds to the
dt_options bit DTOPT_PrimaryKey in the DATATABLES Client control table, which gets its initial value from the parameter
use_primary_key. See the Databridge Client Administrator's Guide for details on the various index types.
User Stored Procedure
This option only applies to MISER databases. It is used to make the client run the stored procedure m_tablename
to process a CREATE record for the table, instead of handling it like a normal CREATE record.
This option corresponds to the bit DTOPT_UserSP in the
dt_options columns of the DATATABLES Client control table.