Parameter

Description

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.

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.

Here's an example suffix for a SQL Server database which specifies file groups for create index statements:

create_index_suffix [1]="ON filegroup"

Here's an example suffix for an Oracle database:

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.

Here's an example suffix for an SQL Server database which specifies filegroups for create table statements:

create_table_suffix [1]="ON filegroup"

Here's an example suffix for an Oracle database:

create_table_suffix [1]="TABLESPACE tablename"

global_index_suffix

Default: None
Range: "suffix"
Applies to: Oracle and SQL Server Clients

The global_index_suffix parameter enables you to add a filegroup (SQL Server) or a tablespace (Oracle) 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 filegroup (SQL Server) or a tablespace (Oracle) 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.