SAS/ACCESS Software for Relational Databases: Reference

SAS/ACCESS Data Set Options: CA-OpenIngres Specifics

This section describes options that can be applied to SAS data sets that access data in CA-OpenIngres tables and views. In some cases, the option is fully described in "SAS/ACCESS Software for Relational Databases," except for some CA-OpenIngres-specific detail, such as a default value. In other cases, the entire option is CA-OpenIngres specific, so it is fully described in this chapter.

When specified in a DATA step or SAS procedure, the following data set options can be used on a SAS data set that accesses data in a DBMS object, such as a table or view. A data set option applies only to the SAS data set, or DBMS object, on which it is specified.

The SAS/ACCESS interface to CA-OpenIngres supports all of the SAS/ACCESS data set options listed in SAS/ACCESS Data Set Options, except for DBCREATE_TABLE_OPTS=, DBGEN_NAMES=, DBLABEL=, 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 CA-OpenIngres or have CA-OpenIngres-specific aspects to them:

DBINDEX=

DBNULL=

DBTYPE=

SASDATEFMT=

SCHEMA=

Chapter Contents
Previous
Next
Top of Page