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.
DBPATH environment variableUse the DBPATH environment variable to identify the database servers that contain databases. DBPATH can also specify a list of directories (in addition to the current directory) in which DB-Access looks for command scripts (.sql files).
Specifying a servername

Specifying a servername

About this task

You can set DBPATH to contain only database server names. This feature allows you to locate only databases; you cannot use it to locate command files.

The database administrator must include each database server mentioned by DBPATH in the $INFORMIXDIR/etc/sqlhosts file. For information about communication-configuration files and dbservernames, see your HCL OneDB™ Administrator's Guide and the HCL OneDB Administrator's Reference.

For example, if INFORMIXSERVER is set to quality, you can search for a database first on the quality database server and then on the marketing database server by setting DBPATH, as the following example shows:

setenv DBPATH //marketing

If you use DB-Access in this example, the names of all the databases on the quality and marketing database servers are displayed with the Select option of the DATABASE menu.