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.

 

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.

 

You must set INFORMIXSERVER even if the application or DB-Access does not use implicit or explicit default connections.

 

Example:

 

Specifies dbserver_main as the default database server:

 

export INFORMIXSERVER=dbserver_main

 

 

Related articles:

CONNECT TO

Connecting to Default Database

INFORMIXDIR

INFORMIXPASS

LOGNAME