Previous Page
|
Next Page
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
Data Set Options for Relational Databases
.
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=
not set
SCHEMA=
LIBNAME option setting
UPDATE_ISOLATION_LEVEL=
LIBNAME option setting
UPDATE_LOCK_TYPE=
LIBNAME option setting
UTILCONN_TRANSIENT=
YES
Copyright © SAS Institute Inc. All rights reserved.
Previous Page
|
Next Page
|
Top of Page