All SAS/ACCESS data set options in this table are supported for Teradata. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.
|
Option |
Default Value |
|---|---|
|
creates a FastExport control file in the temporary file directory that is specified by the UTILLOC= system option with a platform-specific name |
|
|
creates a MultiLoad script file in the temporary file directory that is specified by the UTILLOC= system option or with a platform-specific name |
|
|
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. |
|
|
2 |
|
|
NO |
|
|
none |
|
|
20% |
|
|
LIBNAME option value |
|
|
none |
|
|
none |
|
|
LIBNAME option value |
|
|
NO |
|
|
DBMS |
|
|
LIBNAME option value |
|
|
none |
|
|
NO |
|
|
none |
|
|
none |
|
|
COMPAT |
|
|
none |
|
|
none (no default value) |
|
|
1 |
|
|
NO |
|
|
NO |
|
|
0 |
|
|
none |
|
|
none |
|
|
none |
|
|
none |
|
|
none |
|
|
none |
|
|
NO |
|
|
NO |
|
|
SAS |
|
|
a blank character |
|
|
none |
|
|
none |
|
|
none |
|
|
none |
|
|
YES |
|
|
none |
|
|
LIBNAME option value |
|
|
LIBNAME option value |
|
|
LIBNAME option value |
|
|
none |
|
|
LIBNAME option value |
|
|
none |
|
|
NO |
|
|
6 |
|
|
CURRENT VALIDTIME [valid-time column]CURRENT TRANSACTIONTIME [transaction-time column] |
|
|
0 [FastLoad], 4 [FastExport, MultiLoad] |
|
|
YES |
|
|
NO |
|
|
64330 for Teradata 15.10 and lower 16775168 for Teradata 16.00 and higher |
|
|
64 |
|
|
none |
|
|
none |
|
|
table_name_ET |
|
|
table_name_UV |
|
|
table_name_RS |
|
|
4 |
|
|
1 session |
|
|
20 |
|
|
NO |
|
|
NO |
|
|
1 |
|
|
1 |
|
|
driver name, followed by a timestamp |
|
|
table_name_WT |
|
|
LIBNAME option value |
|
|
LIBNAME option value |
|
|
LIBNAME option value |
|
|
NO |
|
|
none |
|
|
none |