Previous Page | Next Page

SAS/ACCESS Interface to OLE DB

Data Set Options for OLE DB

All SAS/ACCESS data set options in this table are supported for OLE DB. Default values are provided where applicable. For general information about this feature, see Overview.

SAS/ACCESS Data Set Options for OLE DB
Option Default Value
BL_KEEPIDENTITY=
LIBNAME option setting
BL_KEEPNULLS=
LIBNAME option setting
BL_OPTIONS=
LIBNAME option setting
BULKLOAD=
NO
COMMAND_TIMEOUT
LIBNAME option setting
CURSOR_TYPE=
LIBNAME option setting
DBCOMMIT=
LIBNAME option setting
DBCONDITION=
none
DBCREATE_TABLE_OPTS=
LIBNAME option setting
DBFORCE=
NO
DBGEN_NAME=
DBMS
DBINDEX=
LIBNAME option setting
DBKEY=
none
DBLABEL=
NO
DBMASTER=
none
DBMAX_TEXT=
1024
DBNULL=
_ALL_=YES
DBNULLKEYS=
LIBNAME option setting
DBSASLABEL=
COMPAT
DBSASTYPE=
see Data Types for OLE DB
DBTYPE=
see Data Types for OLE DB
ERRLIMIT=
1
IGNORE_ READ_ONLY_COLUMNS=
NO
INSERT_SQL=
LIBNAME option setting
INSERTBUFF=
LIBNAME option setting
NULLCHAR=
SAS
NULLCHARVAL=
a blank character
PRESERVE_COL_NAMES=
LIBNAME option setting
PRESERVE_COL_NAMES=
LIBNAME option setting
READBUFF=
LIBNAME option setting
READ_ISOLATION_LEVEL=
LIBNAME option setting
SASDATEFMT= Data Set Option
not set
SCHEMA=
LIBNAME option setting
UPDATE_ISOLATION_LEVEL=
LIBNAME option setting
UPDATE_LOCK_TYPE=
LIBNAME option setting
UTILCONN_TRANSIENT=
YES

Previous Page | Next Page | Top of Page