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 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 set DELIMIDENT=YES in your
environment.