INFORMIXSQLHOSTS

The INFORMIXSQLHOSTS environment variable specifies where the SQL client or the database server can find connectivity information.

>>-setenv--INFORMIXSQLHOSTS--pathname--------------------------><
 

pathname

is the full pathname of the connectivity information file.

On UNIX systems, the default search path for the connectivity information file is $INFORMIXDIR/etc/sqlhosts.

The following command overrides this default to specify the mysqlhosts file in the /work/envt directory:

setenv INFORMIXSQLHOSTS /work/envt/mysqlhosts

On Windows, INFORMIXSQLHOSTS points to the computer whose registry contains the SQLHOSTS subkey.

The next example specifies that the client or database server look for connectivity information on a computer named arizona:

set INFORMIXSQLHOSTS = \\arizona     

For details of the information that sqlhosts (or a file with a non-default filename) can provide about connectivity, see your IBM Informix: Administrator's Guide.