Options>>

The Options>> button is intended for developers or advanced users only. By selecting the Options>> button, it is possible to specify several initialization parameters. For the c-tree tutorial and the first execution of your ODBC compliant application, FairCom recommends using the default values. The following options are available:

Data Dictionary Path

Default: installed path

FairCom Data Dictionary location in multi-user mode. When using the c-tree Server, the dictionary is created in the c-tree Server directory and should remain there.

The c-tree ODBC Driver searches the Data Dictionary Path for the data dictionary script specified in Script Name. If found, the contents of the script are used to recreate CTSYSCAT.FCS.

Special Data Type Conversion DLL Name

This entry has been added to allow ODBC developers to add support for their own data types with the c-tree Driver SDK.

Max columns per table

Default: 256

Specifies the maximum number of columns to be supported by a given file. The maximum is presently 5000. However, please note that some ODBC compliant applications limit this value to 256 or 300. Even though the c-tree ODBC Driver can open tables with up to 5000 columns, only 300 columns may be specified in a given SQL query select list.

Buffer Sizes - Data/Index

Default: 64

These values set the amount of memory for data and index caching in multi-user non-server mode only. Typically, the larger the value the better the performance. The memory is calculated as follows: Bytes in RAM = (Sector Size X Buffer Size X 128).

Sector Size

Default: 16

Index node size. Set the same value as the target c-tree Plus files, or larger if they are not superfiles. The default value of 16 yields a 2K node size (16 x 128), the default for the c-tree Server. Each time this value is changed, CTSYSCAT.FCS must be recreated to match the new value. Normally, the default value will be best, but your application vendor will know the optimum value for your c-tree Plus files.

Case-insensitive string comparison

Default: OFF

When enabled, causes target string values to be compared to column data without regard to case. For example, “THE” and “the” are identical with this box checked.

OEM to ANSI Data Conversion

Default: OFF

Allows customers to choose to perform the OEM to ANSI conversion for string data. Consult your vendor before changing this setting.

Logon to Server as Guest

Default: ON

Username and password support for client-server mode. When enabled in client-server mode, the c-tree ODBC Driver connects to the c-tree Server as user GUEST. If this option is not enabled, the user is prompted for the username and password when connecting to the c-tree Server.

Column Order

Default: Table Position

This prompt specifies how column names (field names) are displayed. The default method lists the columns in the order they appear in the table. Alternatively, the column names can be ordered By Name, which sorts them in alphabetical order before displaying.

Key Padding

Default: Default

This option allows the padding byte for target key values to be altered. Note: This option should only be used by advanced users.

Alignment

Default: Default

This option allows the default c-tree Plus data file alignment to be altered. Note: This option should only be used by advanced users.

Data Padding

Default: NULLs

This option allows the padding byte for string data to be altered. Note: This option should only be used by advanced users.

c-tree Plus Debug

Default: OFF

Enabling this feature sends debugging information to a log file named CTODBC.LOG.

Debug Indexes

Default: OFF

Enabling this feature sends debugging information to a log file named CTODBC.LOG.