SAS/ACCESS Software for Relational Databases: Reference

Data Set Options: OLE DB Specifics

This section describes SAS data set options that use OLE DB providers to access data sources such as DBMS tables and views. In some cases, the option is fully described in SAS/ACCESS Data Set Options , except for some OLE DB-specific detail, such as a default value. In other cases, the entire option is OLE DB-specific, so it is described fully 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 source, such as a DBMS table or view. A data set option applies only to the SAS data set on which it is specified.

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

COMMAND_TIMEOUT=

CURSOR_TYPE=

DBFORCE=

DBINDEX=

DBNULL=

DBSASTYPE=

DBTYPE=

QUALIFIER=

READ_ISOLATION_LEVEL=

READ_LOCK_TYPE=

ROWSET_SIZE=

SASDATEFMT=

SASDATEINFMT=

SCHEMA=

UPDATE_ISOLATION_LEVEL=

UPDATE_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page

	COMMAND_TIMEOUT=
	CURSOR_TYPE=
	DBFORCE=
	DBINDEX=
	DBNULL=
	DBSASTYPE=
	DBTYPE=
	QUALIFIER=
	READ_ISOLATION_LEVEL=
	READ_LOCK_TYPE=
	ROWSET_SIZE=
	SASDATEFMT=
	SASDATEINFMT=
	SCHEMA=
	UPDATE_ISOLATION_LEVEL=
	UPDATE_LOCK_TYPE=