Installation Guide for Microsoft Windows Environments

Installation Guide for Microsoft Windows Environments
Appendix A:

Home Contents Index Master Index New Book

Environment Variables

The following table lists environment variables that Version 9 client products support. Maximum size does not include the null terminator.


Environment Variable	Purpose	Possible Values (Default Value)
`CC8BITLEVEL`	Specifies how the C language compiler processes non-`ASCII` (8-bit and multibyte) characters.	Refer to Chapter 2 of the . (`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 machine.	Any valid locale specifier. Refer to Chapter 2 of the . (None)
`COLLCHAR`	Specifies a collation sequence for characters. Provided for backward compatibility with NLS products.	Refer to Chapter 4 of the in your pre-7.2 documentation.
`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`)
`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`)
`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`
`DBANSIWARN`	When turned on (`y`), causes the preprocessor to check for extensions to `ANSI`-standard `SQL` syntax at compile time, and causes an application to check for extensions at runtime.	(`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. Refer to `NLS` and `ALS` documentation for descriptions.
`DBASCIIBC`	When set to `1`, enables compatibility with `ASCII` products.	`0` or `1`
`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`. Refer to the , Version 9.1. (`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)
`DBCONNECT`	Specifies whether or not connections are restricted.	`1` or `3`
`DBCSCONV`	Controls code-set conversion initialization. Maximum size is 8 characters. Provided for backward compatibility with ALS products.	`1` or `2`:codesetname Refer to 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.	`0` or `1`
`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.
`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. recommends `GL_DATE` for 7.2 applications.	("`MDY4`" unless `NLS` variable `LC_TIME` is activated)
`DBFLTMASK`	`S`pecifies 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 `%INFORMIXDIR%` directory that contains the product-specific message (.iem) files.	`(\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.	(`n`)
`DBPATH`	Identifies the database servers that contain databases that the application accesses.
`DBSS2`	Maximum size is 4 characters. Provided for backward compatibility with ALS products.	`0x00-0xff` or `0-255`
`DBSS3`	Maximum size is 4 characters. Provided for backward compatibility with ALS products.	`0x00-0xff` or `0-255`
`DBTEMP`	Specifies the directory on the client machine that the client processor uses to store temporary files (also called swap files).	(`\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. recommends GL_DATETIME for 7.2 applications.	(`%Y-%m-%d %H:%M:%S`)
`DELIMIDENT`	Indicates whether (`y`) or not (`n`) to interpret strings in double quotes as delimited identifiers.	(`n`)
`ESQLMF`	Indicates whether the `ESQL/C` processor automatically invokes the `ESQL/C` multibyte filter (value=1 and `CC8BITLEVEL`<3, or not value=0).	Refer to Chapter 2 of the .
`FET_BUF_SIZE`	Enables you to override 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.	Refer to Chapter 2 of the .
`GL_DATETIME`	Specifies a customized end-user format for `DATETIME` values.	Refer to Chapter 2 of the .
`INFORMIXDIR`	Identifies the location of the client programs as well as the location of library files, message files, header files, and other executables.	(`C:\INFORMIX`)
`INFORMIXSERVER`	Identifies the default database server.	Refer to the for Microsoft Windows Environments.
`INFORMIXSQLHOSTS`	Specifies the name of the machine on which the central registry resides.	Refer to the for Microsoft Windows Environments.
`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.	Refer to Chapter 4 of the in your pre-7.2 documentation. (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.	Refer to Chapter 4 of the in your pre-7.2 documentation. (value that `LANG` specifies`)`
`LC_MONETARY`	Specifies the end-user format for `MONEY` values in an `NLS` database. Provided for backward compatibility with NLS products.	Refer to Chapter 4 of the in your pre-7.2 documentation. (value that `LANG`specifies`)`
`LC_NUMERIC`	Specifies the end-user format for numeric values in an `NLS` database. Provided for backward compatibility with `NLS` products.	Refer to Chapter 4 of the in your pre-7.2 documentation. (value that `LANG` specifies`)`
`LC_TIME`	Specifies the end-user format for `DATE` and `DATETIME` values in an `NLS` database. Provided for backward compatibility with NLS products	Refer to Chapter 4 of the in your pre-7.2 documentation. (value that `LANG` specifies`)`

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: the overrides only affect that server.

They are described in the following table.

Environment Variable Overrides the Value For
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.

Installation Guide for Microsoft Windows EnvironmentsAppendix A: Home Contents Index Master Index New Book

Environment Variables

Installation Guide for Microsoft Windows Environments
Appendix A:

Home Contents Index Master Index New Book