SAS/ACCESS Software for Relational Databases: Reference

Data Set Options: ODBC Specifics

This section describes SAS/ACCESS data set options that can be applied to SAS data sets that access data in tables and views using ODBC. All of the data set options described in SAS/ACCESS Data Set Options apply to ODBC. In some cases, an option has an ODBC-specific detail or an entire option is ODBC-specific. If so, these options are described in section.

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 on which it is specified.

The SAS/ACCESS data set options for ODBC are as follows:

CURSOR_TYPE=

DBINDEX=

DBNULL=

DBSASTYPE=

DBTYPE=

KEYSET_SIZE=

QUALIFIER=

QUERY_TIMEOUT=

READ_ISOLATION_LEVEL=

READ_LOCK_TYPE=

ROWSET_SIZE=

SASDATEFMT=

SCHEMA=

UPDATE_ISOLATION_LEVEL=

UPDATE_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page

	CURSOR_TYPE=
	DBINDEX=
	DBNULL=
	DBSASTYPE=
	DBTYPE=
	KEYSET_SIZE=
	QUALIFIER=
	QUERY_TIMEOUT=
	READ_ISOLATION_LEVEL=
	READ_LOCK_TYPE=
	ROWSET_SIZE=
	SASDATEFMT=
	SCHEMA=
	UPDATE_ISOLATION_LEVEL=
	UPDATE_LOCK_TYPE=