GLS-related environment variables

These topics list the GLS-related environment variables that you can set for HCL Informix® database servers and SQL API products.

Important: Some previous releases of HCL Informix supported the GL_PATH environment variable. For all current versions of Informix, however, if you set GL_PATH before you initialize the database server (or any SUID/SGID programs provided by Informix) you get an error and its value is ignored.

CC8BITLEVEL environment variable
The CC8BITLEVEL environment variable determines the type of processing that the IBM® Informix ESQL/C filter, esqlmf, performs on non-ASCII (8-bit and multibyte) characters.
CLIENT_LOCALE environment variable
The CLIENT_LOCALE environment variable specifies the client locale, which the client application uses in read and write operations, display formats, and processing ESQL statements.
DBDATE environment variable (deprecated)
The DBDATE environment variable specifies the display formats of values in DATE columns.
DBLANG environment variable
The DBLANG environment variable specifies the subdirectory of INFORMIXDIR that contains the customized, language-specific message files that the HCL Informix product uses.
DB_LOCALE environment variable
The DB_LOCALE environment variable specifies the database locale, which the database server uses to process locale-sensitive data.
DBMONEY environment variable
The DBMONEY environment variable specifies the custom display formats for values in MONEY columns.
DBTIME environment variable (deprecated)
The DBTIME environment variable specifies the custom display formats of values in DATETIME columns for SQL API routines in the ESQL/C function libraries.
ESQLMF environment variable
The ESQLMF environment variable setting determines whether the esql command automatically starts the esqlmf multibyte filter.
GL_DATE environment variable
The GL_DATE environment variable specifies custom display formats of values for DATE columns.
GL_DATETIME environment variable
The GL_DATETIME environment variable specifies the custom display format of values in DATETIME columns.
GLS8BITFSYS environment variable
Use the GLS8BITFSYS environment variable to tell HCL Informix products (such as the Informix ESQL/C processor) whether the operating system is 8-bit clean.
GL_USEGLU environment variable
The GL_USEGLU environment variable enables GLS for Unicode (GLU). You must use the GL_USEGLU environment variable if you use NCHAR or NVARCHAR data types that require localized collation.
IFX_PUA_DISPLAY_MAPPING environment variable
Use the IFX_PUA_DISPLAY_MAPPING environment variable to set display widths for characters from the Unicode Private Use Area (PUA) ranges according to a mapping file that you supply: $INFORMIXIDR/gls/etc/pua.map. By default, DB-Access and other Informix character-based applications cannot interpret private-use characters.
SERVER_LOCALE environment variable
The SERVER_LOCALE environment variable specifies the server locale, which the database server uses to perform read and write operations that involve operating-system files on the server computer.
USE_DTENV environment variable
In a database where the GL_DATETIME environment variable has a nondefault setting, you cannot process localized DATETIME values correctly in some operations that load or unload data unless USE_DTENV is enabled.

Parent topic: GLS environment variables