Environment variables

There are four environment variables that you must set for the driver.

The following list describes environment variables that you must set for the driver. For more information about environment variables, see the HCL OneDB™ Guide to SQL: Reference.

ONEDB_HOME

Full path of the directory where the HCL OneDB Client Software Development Kit is installed.

On Windows™ platforms, ONEDB_HOME is a registry setting rather than an environment variable. It is set during installation.

PATH

Directories that are searched for executable programs. Your PATH setting must include the path to your $ONEDB_HOME/bin directory.

DBCENTURY (optional)

Controls the setting of year values. DBCENTURY affects a client program when a user issues a statement that contains a date or datetime string that specifies only the last two digits of the year. For example:

insert into datetable (datecol) values ("01/01/01");

The database server stores the date specified in this statement as either 01-01-1901 or 01-01-2001, depending on the DBCENTURY value on the client.

GL_DATE (optional)

GL_DATE controls the interpretation of dates. For example, you can specify whether the date format is mm-dd-yyyy or yyyy-mm-dd.