SAS/ACCESS Software for Relational Databases: Reference

Data Set Options: Teradata 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 Teradata 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 Teradata.

A data set option applies only to the specified table or DBMS object. Unless otherwise noted, when you omit a SAS/ACCESS data set option, and specify a like-named LIBNAME option in the LIBNAME statement, the value specified for the LIBNAME option applies to all tables in the libref.

Note: Not all LIBNAME options have corresponding data set options. Refer to Chapter 3, "SAS/ACCESS LIBNAME Statement" , Chapter 4, "SAS/ACCESS Data Set Options" , and this chapter for a full listing of SAS/ACCESS LIBNAME options, data set options, as well as Teradata-specific LIBNAME and data set options. [cautionend]

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

DBINDEX=

DBNULL=

DBTYPE=

READ_ISOLATION_LEVEL=

READ_LOCK_TYPE=

READ_MODE_WAIT=

SASDATEFMT=

SCHEMA=

UPDATE_ISOLATION_LEVEL=

UPDATE_LOCK_TYPE=

UPDATE_MODE_WAIT=

Chapter Contents
Previous
Next
Top of Page