INFORMIXSERVER

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.

Syntax

INFORMIXSERVER={dbservername}

Possible values

The value of INFORMIXSERVER can be a local or remote server, but must correspond to a valid dbservername entry in the $INFORMIXDIR/etc/sqlhosts file on the computer running the application.

The dbservername must begin with a lower-case letter and cannot exceed 128 bytes. It can include any printable characters except uppercase characters, field delimiters (blank space or tab), the newline character, and the hyphen (or minus) symbol.

Usage

The INFORMIXSERVER environment variable 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. You must set INFORMIXSERVER before you can use IBM Informix client products.

Specifies dbserver_main as the default database server:

export INFORMIXSERVER=dbserver_main

INFORMIXSERVER specifies the database server to which an application connects if the CONNECT DEFAULT statement is executed. It also defines the database server to which an initial implicit connection is established if the first statement in an application is not a CONNECT statement.