(1 of 6)
CC8BITLEVEL
Specifies how the C language compiler processes non-ASCII (8-bit and multibyte) characters.
See INFORMIX-GLS Programmer's Manual.(2)
2
CLIENT_LOCALE
Specifies the locale that the client application uses to perform read/write operations that involve the keyboard, display, file, or printer on the client computer.
Any valid locale specifier. See INFORMIX-GLS Programmer's Manual.(None)
COLLCHAR
Specifies a collation sequence for characters. Provided for backward compatibility with NLS products.
See Informix Guide to SQL: Reference.
CONRETRY
Specifies the maximum number of additional connection attempts made to a database server in the time limit that CONTIME specifies.
Same as INFORMIXCONRETRY.
(1)
1
CONTIME
Specifies the number of seconds an SQL CONNECT statement continues to try to establish a connection before it generates an error.
Same as INFORMIXCONTIME.
(15)
15
DB_LOCALE
Specifies the locale of all the databases that a client application accesses in a single connection (the database locale).
Any valid locale name
DBALSBC
When set to 1, enables compatibility with ALS products.
0 or 1
0
DBANSIWARN
When turned on (y), causes the preprocessor to check for Informix extensions to ANSI-standard SQL syntax at compile time, and causes an application to check for Informix extensions at runtime.
y
(n)
n
DBAPICODE
Enables pre-7.2 systems that use nonstandard or rare code sets to access databases that store data in a standard code set. Maximum size = 23 characters. Provided for backward compatibility with NLS and ALS products.
Usage and values depend on language system. See NLS and ALS documentation for descriptions.
DBASCIIBC
When set to 1, enables compatibility with ASCII products.
DBCENTURY
Specifies how to expand values of two-digit-year DATE and DATETIME values. P = past century, R = present century,C = closest century.
P
R
C
P, R, or C.See Informix Guide to SQL: Reference.(R)
DBCODESET
Specifies an Asian-locale code set. Overrides the code set that DB_LOCALE specifies. Provided for backward compatibility with Version 4.x and 5.x ALS products.
Same values as ALS DBAPICODE.("8859-1::" unless the informix.rc file specifies another system-wide default)
8859-1::
DBCONNECT
Specifies whether or not connections are restricted.
1 or 3
3
DBCSCONV
Controls code-set conversion initialization. Maximum size is eight characters. Provided for backward compatibility with ALS products.
1 or 2:codesetname
See 5.0 ALS documentation.
DBCSOVERRIDE
Forces the user-specified DB_LOCALE value to override default restrictions on accessing databases with locales different from DB_LOCALE. Provided for backward compatibility with Version 6.0 ALS database servers.
DBCSWIDTH
Maximum number of display bytes (1-2) and storage bytes (1-4) for the characters in up to three code sets. Display and storage widths are separated by commas; code sets are separated by colons. Maximum size of this field is, therefore, 11 characters. Provided for backward compatibility with ALS products.
Example:1,1:2,3 means a display and storage width of 1 byte for character set 1; a display width of 2 bytes and a storage width of 3 bytes for code set 2.
1,1:2,3
DBDATE
Specifies the end-user format for DATE values so that they can conform with various international date conventions. Provided for backward compatibility with pre-7.2 products. Informix recommends GL_DATE for 7.2 ESQL/C applications.
("MDY4"unless NLS variable LC_TIME is activated)
"MDY4"
DBFLTMASK
Specifies the number of decimal digits to use when storing a DECIMAL, SMALLFLOAT, or FLOAT data type in a character buffer.
0-16 (16)
DBLANG
Specifies the subdirectory of the Informix installation directory that contains the product-specific message (.iem) files.
(\msg)
\msg
DBMONEY
Specifies the end-user format for MONEY values so that they can conform with various international and local monetary conventions.
($.,)
$.,
DBMONEYSCALE
Specifies the total number of digits and number of decimal digits for monetary values. Provided for backward compatibility with ALS products.
DBNLS
Specifies whether an application can access NLS features. Provided for backward compatibility with NLS products.
DBPATH
Identifies the database servers that contain databases that the application accesses.
DBSS2
Maximum size is four characters. Provided for backward compatibility with ALS products.
0x00-0xff or0-255
0x00-0xff
0-255
DBSS3
DBTEMP
Specifies the directory on the client computer that the client processor uses to store temporary files (also called swap files).
(\tmp)
\tmp
DBTIME
Specifies the end-user format for DATETIME values so that they can conform with various international date conventions. Provided for backward compatibility with pre-7.2 products. Informix recommends GL_DATETIME for 7.2 ESQL/C applications.
(%Y-%m-%d %H:%M:%S)
%Y-%m-%d %H:%M:%S
DELIMIDENT
Indicates whether (y) or not (n) to interpret strings in double quotes as delimited identifiers.
ESQLMF
Indicates whether the ESQL/C processor automatically invokes the ESQL/C multibyte filter (value=1 and CC8BITLEVEL<3, or not value=0).
See INFORMIX-GLS Programmer's Manual.
FET_BUF_SIZE
Overrides the default size of the fetch buffer.
Any valid buffer size, in bytes.
(Default value depends on row size.)
GL_DATE
Specifies a customized end-user format for DATE values.
GL_DATETIME
Specifies a customized end-user format for DATETIME values.
INFORMIXDIR
Identifies the location of the client programs, library files, message files, header files, and other Informix software components.
(C:\INFORMIX)
C:\INFORMIX
INFORMIXSERVER
Identifies the default database server.
See INFORMIX-ESQL/C Programmer's Supplement for Microsoft Windows Environments.
INFORMIXSQLHOSTS
Specifies the name of the computer on which the central registry resides.
LANG
Specifies the language environment (called a locale) for an NLS database that an application accesses. Provided for backward compatibility with NLS products.
(C)
LC_COLLATE
Specifies a collation or sort sequence for data in NCHAR and NVARCHAR columns of an NLS database. Provided for backward compatibility with NLS products.
(value that LANG specifies)
LC_CTYPE
Specifies character attributes such as character classification and case conversion of regular expressions for data in NCHAR and NVARCHAR columns of an NLS database. Provided for backward compatibility with NLS products.
LC_MONETARY
Specifies the end-user format for MONEY values in an NLS database. Provided for backward compatibility with NLS products.
LC_NUMERIC
Specifies the end-user format for numeric values in an NLS database. Provided for backward compatibility with NLS products.
LC_TIME
Specifies the end-user format for DATE and DATETIME values in an NLS database. Provided for backward compatibility with NLS products
In addition, there is a set of environment variables you can use with the function call ifx_putenv to override the information entered in the Server Information and Host Information tabbed pages of Setnet32. To use these environment variables, you must set the INFORMIXSERVER environment variable to a valid server name. Overrides only affect that server. The environment variables are described in the following table.
WIN32HOST
The HOST network parameter
WIN32USER
The USER network parameter
WIN32PASS
The PASSWORD network parameter
WIN32ASKPASSATCONNECT
The PASSWORD OPTION network parameter
WIN32SERVICE
The SERVICE network parameter
WIN32PROTOCOL
The PROTOCOL network parameter
See the INFORMIX-ESQL/C Programmer's Supplement for Microsoft Windows Environments for more information.
