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