16.10 - FastLoad Utility and the Load Operator - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The following table lists the operating features and capabilities of the Teradata FastLoad utility, and indicates whether they are supported by the Load operator.

Load Operator Supported Features 
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