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.

SAS/ACCESS Data Set Options for Teradata

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 TableName_SE1_randnum and TableName_SE2_randnum. TableName consists of up to the first 15 characters of the target table name, and 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
MBUFFSIZE=	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
SASDATEFMT=	none
SCHEMA=	the current LIBNAME option setting
SESSIONS=	none
SET=	NO
SLEEP=	6
TEMPORAL_QUALIFIER=	CURRENT VALIDTIME [valid-time column]CURRENT TRANSACTIONTIME [transaction-time column]
TENACITY=	0 [FastLoad], 4 [FASTEXPORT=, MultiLoad]
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_SESSION=	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