 |
|
| SAS/ACCESS Interface to Teradata |
Data Set Options for Teradata
All SAS/ACCESS data set options in this table are supported for Teradata. Default values are provided where applicable. For details about this feature, see Overview.
| Option | Default Value |
|---|---|
|
BL_CONTROL= |
creates a FastExport control file in the current directory with a platform-specific name |
|
BL_DATAFILE= |
creates a MultiLoad script file in the current directory or with a platform-specific name |
|
BL_LOG= |
FastLoad errors are logged in Teradata tables named SAS_FASTLOAD_ERRS1_randnum and SAS_FASTLOAD_ERRS2_randnum, where randnum is a randomly generated number. |
|
BUFFERS= |
2 |
|
BULKLOAD= |
NO |
|
CAST= |
none |
|
CAST_OVERHEAD_MAXPERCENT= |
20% |
|
DBCOMMIT= |
the current LIBNAME option setting |
|
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 |
|
DBMASTER= |
none |
|
DBNULL= |
none |
|
DBSASLABEL= |
COMPAT |
|
DBSASTYPE= |
see Data Types for Teradata |
|
DBSLICE= |
none |
|
DBSLICEPARM= |
THREADED_APPS,2 |
|
DBTYPE= |
see Data Types for Teradata |
|
ERRLIMIT= |
1 |
|
MBUFSIZE= |
0 |
|
ML_CHECKPOINT= |
none |
|
ML_ERROR1= |
none |
|
ML_ERROR2= |
none |
|
ML_LOG= |
none |
|
ML_RESTART= |
none |
|
ML_WORK= |
none |
|
MULTILOAD= |
NO |
|
MULTISTMT= |
NO |
|
NULLCHAR= |
SAS |
|
NULLCHARVAL= |
a blank character |
|
PRESERVE_COL_NAMES= |
YES |
|
QUERY_BAND= |
none |
|
READ_ISOLATION_LEVEL= |
the current LIBNAME option setting |
|
READ_LOCK_TYPE= |
the current LIBNAME option setting |
|
READ_MODE_WAIT= |
the current LIBNAME option setting |
|
SASDATEFORMAT= |
none |
|
SCHEMA= |
the current LIBNAME option setting |
|
SESSIONS= |
none |
|
SET= |
NO |
|
SLEEP= |
6 |
|
TENACITY= |
4 |
|
TPT= |
YES |
|
TPT_APPL_PHASE= |
NO |
|
TPT_BUFFER_SIZE= |
64 |
|
TPT_CHECKPOINT_DATA= |
none |
|
TPT_DATA_ENCRYPTION= |
none |
|
TPT_ERROR_TABLE_1= |
table_name_ET |
|
TPT_ERROR_TABLE_2= |
table_name_UV |
|
TPT_LOG_TABLE= |
table_name_RS |
|
TPT_MAX_SESSIONS= |
1 session per available Access Module Processor (AMP) |
|
TPT_MIN_SESSIONS= |
1 session |
|
TPT_PACK= |
20 |
|
TPT_PACKMAXIMUM= |
NO |
|
TPT_RESTART= |
NO |
|
TPT_TRACE_LEVEL= |
1 |
|
TPT_TRACE_LEVEL_INF= |
1 |
|
TPT_TRACE_OUTPUT= |
driver name, followed by a timestamp |
|
TPT_WORK_TABLE= |
table_name_WT |
|
UPDATE_ISOLATION_LEVEL= |
the current LIBNAME option setting |
|
UPDATE_LOCK_TYPE= |
the current LIBNAME option setting |
|
UPDATE_MODE_WAIT= |
the current LIBNAME option setting |
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.