The three main differences between using SAS/ACCESS to Informix with SAS
8 versus SAS 9 are:

* Using an ODBC.INI file at SAS 9
* Include $INFORMIXDIR/lib/cli in the shared library path as well as
   $INFORMIXDIR/lib/esql at SAS 9
* Use server= instead of database= at SAS 9

When setting up Informix for 9 and later, you must adhere to the
following requirements, which can be found in the Configuration Guide:

For SAS 9 of the SAS System, SAS/ACCESS Interface to INFORMIX
software uses an ODBC  interface to access Informix. Make sure that
Informix Connect 2.70 or higher is installed. You may have to edit the
.odbc.ini file in your home directory with a text editor to configure
data sources.

Some ODBC driver vendors may allow system administrators to maintain a
centralized copy by setting the environment variable ODBCINI.
Please refer to  your ODBC driver's vendor documentation for more
specific information.

The ODBC drivers are ODBC API-compliant shared libraries, referred to
in UNIX as shared objects.  You must add the location of the shared
libraries to one of the system environment variables so that ODBC
drivers can be loaded dynamically at run time.

You must also set the INFORMIXDIR environment variable to your Informix
home directory before setting the  environment variables as shown in the
examples.

AIX
Bourne Shell
$ LIBPATH=$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LIBPATH
$ export LIBPATH
C Shell
$ setenv LIBPATH $INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LIBPATH


HP-UX
Bourne Shell
$ SHLIB_PATH=$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$SHLIB_PATH
$ export SHLIB_PATH
C Shell
$ setenv SHLIB_PATH
INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$SHLIB_PATH

Compaq Tru64 UNIX and Solaris
Bourne Shell
$ LD_LIBRARY_PATH=$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:
$LD_LIBRARY_PATH
$ export LD_LIBRARY_PATH
C Shell
$ setenv LD_LIBRARY_PATH
$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH

You must use the following syntax when connnecting to INFORMIX:

   proc sql;
     connect to informix(server="server_name");

The syntax used in previous releases will not work in SAS 9.  For
example,this CONNECT statement will generate an error in SAS 9:

   proc sql;
     connect to informix(database='database_name' );

The error you will receive is:

ERROR: Informix CONNECT Error: DATABASE= option is no longer supported
in libname or connect command. Specify database in odbc.ini.

Operating System and Release Information