FastLoad Utility and the Load Operator
Table 15 lists the operating features and capabilities of the Teradata FastLoad utility, and indicates whether they are supported by the Load operator.
|
FastLoad Utility Feature |
Teradata PT Operator Support |
|
Access Modules |
Supported, using the DataConnector operator |
|
ANSI Date |
Supported |
|
Checkpoint/Restart |
Supported |
|
Character Sets |
Supported, using the USING CHARACTER SET clause before the DEFINE JOB statement |
|
Configuration File |
Supported, using the tbuild command line job attribute option (-v) |
|
CREATE TABLE Statement |
Supported, using the DDL operator |
|
DATABASE Statement |
Supported |
|
DELETE Statement |
Supported, using the DDL operator |
|
DROP TABLE Statement |
Supported, using the DDL operator |
|
Error Limit |
Supported |
|
Indicator Mode |
Supported, using the DataConnector operator |
|
INMOD Routines |
Supported, using the FastLoad INMOD Adapter operator |
|
Maximum/Minimum Sessions |
Supported |
|
Nonindicator Mode |
Supported, using the DataConnector operator |
|
Notify |
Supported |
|
NULLIF Clauses |
Supported, but not the XB, XC, and XG data types |
|
Operating System Command |
Supported, using the OS Command operator |
|
Record Formats |
Supported, using the DataConnector operator |
|
RECORD n THRU m |
Supported, in a limited form by the DataConnector operator, allowing you to read in the first “m” rows of a file, effectively allowing “RECORD 1 THRU m” |
|
Show Version Information |
Supported |
|
Tenacity |
Supported |
|
Wildcard INSERT |
Supported |