SAS/ACCESS Software for Relational Databases: Reference

Default Environment

When you access Informix tables by using the SAS/ACCESS Interface to Informix, the default Informix read isolation level is set for committed reads, and SAS spooling is on. Committed reads allow 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 will get identical data each time you reread a row because SAS buffers the rows after you read them the first time. This default environment is suitable for most users; however, this chapter describes how to set the locking and read isolation level options if the default environment is unsuitable for your needs.

For more details on Informix locking, see your Informix documentation. To see the SQL statements, including locking statements, that SAS issues to the Informix server, include the following option in your code:

option sastrace=',,,d';

Note: If you use quotes in your Informix SQL statements, your DELIMIDENT environment variable should be set to DELIMIDENT=YES, or your statements could be rejected by Informix. Because some of the SAS options that preserve case generate SQL statements that contain quotes, DELIMIDENT=YES should be set in your environment. [cautionend]

Chapter Contents
Previous
Next
Top of Page