SAS/ACCESS Software for Relational Databases: Reference

Data Set Options: Informix Specifics

SAS/ACCESS Data Set Options describes the SAS/ACCESS options that you can use when you specify a SAS data set in a DATA or PROC step; in this case, the SAS data set accesses data from a DBMS table or view. The following section describes the DBMS-specific options and option values that you can use in the SAS/ACCESS Interface to Informix. A data set option applies only to the SAS data set, or DBMS object, on which it is specified.

Unless otherwise noted, when you omit a SAS/ACCESS data set option, and you have specified a like-named LIBNAME option in the LIBNAME statement, the value of the LIBNAME option applies to all data sets within the libref.

Note: Not all LIBNAME options have corresponding data set options. [cautionend]

The SAS/ACCESS interface to Informix supports all of the SAS/ACCESS data set options listed in SAS/ACCESS Data Set Options, except for DBMAX_TEXT=, READ_LOCK_TYPE, and UPDATE_LOCK_TYPE. In addition to the supported options, the following data set options are used only in the interface to Informix or have Informix-specific aspects to them:

DBNULL=

DBTYPE=

LOCKTABLE=

SASDATEFMT=

SCHEMA=

Chapter Contents
Previous
Next
Top of Page