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 |