Database Environment Variables

 

Variable

Description

Possible values and their meaning

Related articles

CLIENT_LOCALE

Specifies the language, territory, and code set that the client application uses in I/O operations, end user formats, and processing ESQL statements.

 

CLIENT_LOCALE=fr_ca.8859-1

 

<language>_<territory>.<code_set>@modifier

Localization Settings

Guide for Locale Settings

DB_LOCALE

Specifies the Informix database locale, which the Informix database server uses to process locale-sensitive data.

 

DB_LOCALE=fr_ca.8859-1

 

<language>_<territory>.<code_set>@modifier

Localization Settings

Guide for Locale Settings

INFORMIXDIR

Specifies the directory, which contains subdirectories in which your Informix® product files are installed.

 

INFORMIXDIR=/opt/IBM/informix

 

<directory_path>

CONNECT TO

Setting up Informix connection

INFORMIXPASS

Specifies the password valid on Informix database server.

 

INFORMIXPASS=password-123

 

{any set of symbols and/or characters}

Precedence of Parameters

Setting up Informix connection

INFORMIXSERVER

Specifies the default database server to which an explicit or implicit connection is made by an SQL API client, the DB-Access utility, or another IBM® Informix product.

 

export INFORMIXSERVER=dbserver_main

 

{dbservername}

Connecting to Default Database

Setting up Informix connection

LOGNAME

Specifies the user name valid on Informix database server.

 

LOGNAME=informix

 

{string}

Legacy Database Settings

Precedence of Parameters

Setting up Informix connection

 

ODBC_DSN

Specifies the base ODBC connection string for the database connection.

 

ODBC_DSN=DSN=mysql;USER=informix;Password=123456;Database=dbname

{DSN name}

DATABASE

Legacy Database Settings

Lycia Configuration

ODBCINI

Setting up SQL Server connection

 

ODBCINI

Specifies the full path to the the odbc.ini file.

 

ODBCINI=/etc/odbc.ini

 

<file_path>

ODBC client

 

ORACLE_HOME

Specifies the directory, where your Oracle® product is installed.

 

ORACLE_HOME=C:\ORACLE\instantclient_ver._No

 

<directory_path>

Setting up Oracle connection

ORACLE_SID

Specifies the default server instance for current connection.

 

ORACLE_SID=querix_ora

 

{server_instance}

Setting up Oracle connection

QXTRANS

Specifies path to the directory which contains dbtrans file on UNIX. The dbtrans configuration file contains mappings from database names used in 4GL code (for example, DATABASE <dbname>) to an Oracle user logon string.

 

QXTRANS=$ORACLE_HOME/sqldeveloper/ide

 

<directory_path>

Setting up Oracle connection

TNS_ADMIN

Specifies the directory containing the Oracle Net Services configuration files.

 

TNS_ADMIN=$ORACLE_HOME/network/admin

<directory_path>

Setting up Oracle connection

 

 

Please, note that you can use Linux- as well as Windows-type variable syntax on the Windows OS.

I.e. on Windows, Lycia3 will understand both $VARIABLE and %VARIABLE% for variables configured through system tools and for variables located in configuration files (inet.env, env.properties, etc).
 

 

Lycia Configuration