SAS/ACCESS Software for Relational Databases: Reference

Data Set Options: ORACLE 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 ORACLE. A data set option applies only to the 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 data set options for ORACLE are as follows:

DBFORCE=

DBINDEX=

DBLINK=

DBNULL=

DBPROMPT=

DBSASTYPE=

DBTYPE=

INSERTBUFF=

ORHINTS=

READ_ISOLATION_LEVEL=

READ_LOCK_TYPE=

READBUFF=

SASDATEFMT=

SCHEMA=

UPDATEBUFF=

UPDATE_ISOLATION_LEVEL=

UPDATE_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page

	DBFORCE=
	DBINDEX=
	DBLINK=
	DBNULL=
	DBPROMPT=
	DBSASTYPE=
	DBTYPE=
	INSERTBUFF=
	ORHINTS=
	READ_ISOLATION_LEVEL=
	READ_LOCK_TYPE=
	READBUFF=
	SASDATEFMT=
	SCHEMA=
	UPDATEBUFF=
	UPDATE_ISOLATION_LEVEL=
	UPDATE_LOCK_TYPE=