SAS/ACCESS Interface for Informix

Introduction to SAS/ACCESS Interface to Informix

This section describes SAS/ACCESS Interface to Informix. See SAS/ACCESS Interface to Informix: Supported Features for a list of SAS/ACCESS features that are available in this interface. For background information about Informix, see Overview of Informix Servers.

Default Environment

When you access Informix tables by using SAS/ACCESS Interface to Informix, the default Informix read isolation level is set for committed reads, and SAS spooling is on. Committed reads enable you to read rows unless another user or process is updating the rows. Reading in this manner does not lock the rows. SAS spooling guarantees that you get identical data each time you re-read a row because SAS buffers the rows after you read them the first time. This default environment is suitable for most users. If this default environment is unsuitable for your needs, see Locking in the Informix Interface.

To see the SQL statements that SAS issues to the Informix server, include the SASTRACE= option in your code:

option sastrace=',,,d';

If you use quotation marks in your Informix SQL statements, set your DELIMIDENT= environment variable to DELIMIDENT=YES or Informix might reject your statements. Because some SAS options that preserve case generate SQL statements that contain quotation marks, you should set DELIMIDENT=YES in your environment.

Top of Page