SAS/ACCESS Interface to 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.
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 |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.