INFORMIXSQLHOSTS

Home | Previous Page | Next Page Environment Variables > Environment Variables >

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.

UNIX Only

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

End of UNIX Only

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

setenv INFORMIXSQLHOSTS /work/envt/mysqlhosts

Windows Only

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

End of Windows Only

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.