Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThese topics contain 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™.The 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.
IMCADMIN environment variable

IMCADMIN environment variable

The IMCADMIN environment variable supports the imcadmin administrative tool by specifying the name of a database server through which imcadmin can connect to MaxConnect. For imcadmin to operate correctly, you must set IMCADMIN before you use any HCL OneDB™ products.

setenvIMCADMINdbservername

dbservername: is the name of a database server.

Here dbservername must be listed in the sqlhosts file on the computer where the MaxConnect runs. MaxConnect uses this setting to obtain the following connectivity information from the sqlhosts file:

Where the administrative listener port must be established
The network protocol that the specified database server uses
The host name of the system where the specified database server is located

You cannot use the imcadmin tool unless IMCADMIN is set to a valid database server name.

For more information about using IMCADMIN, see HCL OneDB MaxConnect User's Guide.