Data Set Options for Oracle

All SAS/ACCESS data set options in this table are supported for Oracle. 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 Oracle

Option	Default Value
BL_BADFILE=	creates a file in the current directory or with the default file specifications
BL_CONTROL=	creates a control file in the current directory or with the default file specifications
BL_DATAFILE=	creates a file in the current directory or with the default file specifications
BL_DEFAULT_DIR=	<database-name>
BL_DELETE_DATAFILE=	YES
BL_DELETE_ONLY_DATAFILE=	none
BL_DIRECT_PATH=	YES
BL_DISCARDFILE=	creates a file in the current directory or with the default file specifications
BL_INDEX_OPTIONS=	the current SQL*Loader Index options with bulk-loading
BL_LOAD_METHOD=	When loading an empty table, the default value is INSERT. When loading a table that contains data, the default value is APPEND.
BL_LOG=	If a log file does not already exist, it is created in the current directory or with the default file specifications. If a log file does already exist, the Oracle bulk loader reuses the file, replacing the contents with information from the new load.
BL_OPTIONS=	ERRORS=1000000
BL_PRESERVE_BLANKS=	NO
BL_RECOVERABLE=	YES
BL_RETURN_WARNINGS_AS_ERRORS=	NO
BL_SQLLDR_PATH=	sqldr
BL_SUPPRESS_NULLIF=	NO
BL_USE_PIPE=	NO
BULKLOAD=	NO
DBCOMMIT=	the current LIBNAME option setting
DB_ONE_CONNECT_PER_THREAD=	YES
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	the current LIBNAME option setting
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	the current LIBNAME option setting
DBKEY=	none
DBLABEL=	NO
DBLINK=	the current LIBNAME option setting
DBMASTER=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	the current LIBNAME option setting
DBPROMPT=	the current LIBNAME option setting
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Oracle
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2
DBTYPE=	see LIBNAME Statement Data Conversions
ERRLIMIT=	1
INSERTBUFF=	the current LIBNAME option setting
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
OR_PARTITION=	an Oracle table partition name
OR_UPD_NOWHERE=	the current LIBNAME option setting
ORHINTS=	no hints
PRESERVE_COL_NAMES=	current LIBNAME option setting
READ_ISOLATION_LEVEL=	the current LIBNAME option setting
READ_LOCK_TYPE=	the current LIBNAME option setting
READBUFF=	the current LIBNAME option setting
SASDATEFORMAT=	DATETIME20.0
SCHEMA=	the current LIBNAME option setting
UPDATE_ISOLATION_LEVEL=	the current LIBNAME option setting
UPDATE_LOCK_TYPE=	the current LIBNAME option setting
UPDATEBUFF=	the current LIBNAME option setting