FastLoad Utility and the Load Operator - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

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