For available SAS/ACCESS features, see Informix supported features. For background information about Informix, see Informix servers. For more information about Informix, see your Informix documentation.
When you access Informix tables by using SAS/ACCESS Interface to Informix, the default Informix Read isolation level is specified 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 obtain 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 specify DELIMIDENT=YES in your environment.