After you upgrade to SAS 9, SAS/ACCESS Interface to Informix freezes (locks up) when you try to create or drop the same table repeatedly. The following error message might also be issued:

To resolve this problem, apply the hot fix listed at the bottom of this note. The hot fix does the following:

1. AUTOCOMMIT= option is set to ON by default, which means that each command that users issue will be committed automatically. This behavior simulates the behavior in SAS® 8.
2. Users can turn off the AUTOCOMMIT= option either in the LIBNAME statement or in an SQL procedure, as follows:
   1. SQL Pass-Through Facility:

          proc sql; 
             connect to informix(user=&ltuser_id> using=xxxxx 
                                 server=odbc17log autocommit=no); 
              

   2. LIBNAME statement:

          libname x informix user=&ltuser_id> using=xxxxx 
                  server=odbc17log autocommit=no; 
             

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :