The following table 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 |