Variable |
Description |
Possible values and their meaning |
Related articles |
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 |
||
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 |
||
Specifies the directory, which contains subdirectories in which your Informix® product files are installed.
INFORMIXDIR=/opt/IBM/informix
|
<directory_path> |
||
Specifies the password valid on Informix database server.
INFORMIXPASS=password-123
|
{any set of symbols and/or characters} |
||
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} |
||
Specifies the user name valid on Informix database server.
LOGNAME=informix
|
{string} |
Setting up Informix connection
|
|
Specifies the base ODBC connection string for the database connection.
ODBC_DSN=DSN=mysql;USER=informix;Password=123456;Database=dbname |
{DSN name} |
Lycia Configuration Setting up SQL Server connection
|
|
Specifies the full path to the the odbc.ini file.
ODBCINI=/etc/odbc.ini
|
<file_path> |
|
|
Specifies the directory, where your Oracle® product is installed.
ORACLE_HOME=C:\ORACLE\instantclient_ver._No
|
<directory_path> |
||
Specifies the default server instance for current connection.
ORACLE_SID=querix_ora
|
{server_instance} |
||
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> |
||
Specifies the directory containing the Oracle Net Services configuration files.
TNS_ADMIN=$ORACLE_HOME/network/admin |
<directory_path> |
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