Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Environment variablesVarious environment variables affect the functionality of your HCL OneDB™ products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Using environment variables on UNIX™You can set, unset, modify, and view environment variables. If you already use any HCL OneDB™ products, some or all of the appropriate environment variables might be set.
Rules of precedence for environment variables

Rules of precedence for environment variables

When HCL OneDB™ products accesses an environment variable, normally the following rules of precedence apply:

Of highest precedence is the value that is defined in the environment (shell) by explicitly setting the value at the shell prompt.
The second highest precedence goes to the value that is defined in the private environment-configuration file in the home directory of the user (~/.informix).
The next highest precedence goes to the value that is defined in the common environment-configuration file ($INFORMIXDIR/etc/informix.rc).
The lowest precedence goes to the default value, if one exists.

For precedence information about GLS environment variables, see the HCL OneDB GLS User's Guide.

Important: If you set one or more environment variables before you start the database server, and you do not explicitly set the same environment variables for your client products, the clients will adopt the original settings.