Generate Command Parameters

The following generate command parameters determine what SQL statements (for DATABridge Client scripts) will be created. The following parameters are in the [params] section of the DATABridge Client configuration file.

Important: Suffixes must be entered in quotation marks and on a single line. They can be 256 characters in length.

Parameter	Description
create_index_suffix	Default: None Range: "suffix" Applies to: Oracle and SQL Server Clients The create_index_suffix enables you to define extra attributes (a suffix) for create index SQL statements that the program generates for any given table. Each attribute list is defined with a number or index n so you can reference it. Up to 100 different suffixes can be defined. Individual indexes can select one of the suffixes by specifying this value 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. An example suffix for an Oracle database follows: create_index_suffix [1]="TABLESPACE name STORAGE MINEXTENTS 1 NEXT 10 MAXEXTENTS UNLIMITED"
create_table_suffix	Default: None Range: "suffix" The create_table_suffix enables you to define a suffix for create table SQL statements that the program generates for any given table and to assign a number to this suffix so you can reference it. The index n allows for up to 100 different suffixes to be defined. 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 that specify the given suffix number. An example suffix for an Oracle database follows: create_table_suffix [1]="TABLESPACE tablename"
decimal_aa_length	Default: 15 Range: 15 - 38 Applies to: Oracle Client Use this parameter to control the size of the data type that represents a decimal AA value—by default, this is NUMBER(15). If you set this parameter to 16, the client will use NUMBER(16) for all decimal AA values.
global_index_suffix	Default: None Range: "suffix" Applies to: Oracle and SQL Server Clients The global_index_suffix parameter enables you to add a tablespace or any other SQL command specification to all create index SQL statements that the program generates except those that have a suffix associated with the create_index_suffix parameter.
global_table_suffix	Default: None Range: "suffix" The parameter global_table_suffix allows you to add a tablespace or any other SQL command specification to all the create table SQL statements that the Client generates, except for statements whose suffix is associated with the create_table_suffix parameter.