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 |