SAS/ACCESS Software for Relational Databases: Reference

SAS/ACCESS Data Set Options: DB2 Specifics

This section describes options that can be applied to SAS data sets that access data in DB2 tables and views. In some cases, the option is fully described in SAS/ACCESS Data Set Options , except for some DB2-specific detail, such as a default value. In other cases, the entire option is DB2 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 DB2 supports all of the SAS/ACCESS data set options listed in SAS/ACCESS Data Set Options, except for DBINDEX=, DBPROMPT=, DBMAX_TEXT=, and SASDATEFMT=. In addition to the supported options, the following data set options are used only in the interface to DB2 or have DB2-specific aspects to them:

AUTHID=

DBNULL=

DBTYPE=

IN=

LOCATION=

READ_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Note: The DBINDEX= data set option is not supported in the SAS/ACCESS interface to DB2. [cautionend]

Chapter Contents
Previous
Next
Top of Page

	AUTHID=
	DBNULL=
	DBTYPE=
	IN=
	LOCATION=
	READ_LOCK_TYPE=
	UPDATE_LOCK_TYPE=