contents.gifindex.gifprev1.gifnext1.gif

Informix: Configuration File Variables

These are the runtime configuration file variables that are specific to Informix. Configuration file variables that are generally applicable to any RDBMS with which Acu4GL communicates are discussed in this online document. See the runtime configuration topic for important information about setting the DEFAULT-HOST and DATABASE variables.

A-INFORMIX-ERROR-FILE

This configuration file variable allows you to map errors using a text file to supplement the default method of providing errors. By adding the name of the file that contains the actual error mapping to A_INFORMIX_ERROR_FILE, database specific errors are mapped to COBOL errors.

Example

A sample syntax for this configuration file variable would be:

A_INFORMIX_ERROR_FILE=INFerrs

where:

INFerrs is a file of a specified format containing a mapping of database specific errors to COBOL errors. One same entry might be:

1 DUPLICATE_RECORD

INF-LOGIN

INF-LOGIN is available for use with Informix versions 5.x and 7.x. It indicates the user name under which you want to connect to the database system. This is an optional variable. If INF-LOGIN and INF-PASSWD are not set, then a default login is performed. If these variables are set, there must be a matching UNIX login name and password.

Example

To connect to the database with the user name MYNAME, you would specify:

INF-LOGIN MYNAME

in the configuration file.

See also

INF-PASSWD configuration variable.

INF-PASSWD

The variable INF-PASSWD is available for use with Informix versions 5.x and 7.x. It should be set to the password assigned to the database account associated with the user name specified by INF-LOGIN. If INF-LOGIN and INF-PASSWD are not set, then a default login is performed. If these variables are set, there must be a matching UNIX login name and password.

Example

For example, if the account with the user name has the associated password CW021535, you would specify:

INF-PASSWD CW021535

in the configuration file or the environment.

See also

INF-LOGIN configuration variable.

MAX-CURSORS

MAX-CURSORS is the number of cursors (parameterized queries) in Acu4GL's cursor cache. The default value is 100. The range is 1-100. If you set this variable to a number less than the maximum of 100, you may reduce the number you specify in the Informix system parameter open_cursors by a like amount. The value of Informix's open_cursors should exceed MAX-CURSORS by at least 7.

Example

To allow your application to use up to 23 cursors, you would specify:

MAX-CURSORS 23

in the configuration file.