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.
Environment variables in HCL OneDB™ productsThe topics that follow discuss (in alphabetic order) environment variables that HCL OneDB™ database server products and their utilities use.
ONEDB_HOME environment variable

ONEDB_HOME environment variable

The ONEDB_HOME environment variable specifies the directory that contains the subdirectories in which your product files are installed. You must always set ONEDB_HOME. Verify that ONEDB_HOME is set to the full pathname of the directory in which you installed your database server. If you have multiple versions of a database server, set ONEDB_HOME to the appropriate directory name for the version that you want to access. For information about when to set ONEDB_HOME, see your HCL OneDB™ Installation Guide.

pathname: is the directory path where the product files are installed.

To set ONEDB_HOME to usr/informix/, for example, as the installation directory, enter the following command:

setenv ONEDB_HOME /usr/informix

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.