16.10 - TPump Utility and the Stream 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 TPump utility and indicates whether they are supported by the Stream operator or another Teradata PT operator.

Stream Operator Feature Support 
TPump Utility Feature Stream Operator
Absolute field positioning (handled by the FIELD command) Not supported
Access Modules Supported, using the DataConnector operator
ANSI Date Supported
ARRAY support for DML statements 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
Environment variable Not supported
Error Limit Supported
EXECUTE Supported, using the APPLY Statement
IF-ELSE-ENDIF constructs Not supported
Indicator Mode Supported, using the DataConnector operator
INMOD Routines Supported, via the MultiLoad INMOD Adapter operator
Maximum/Minimum Sessions Supported
MARK/IGNORE EXTRA UPDATE/DELETE DML Option Supported, using the MARK/IGNORE EXTRA UPDATE/DELETE DML option in the APPLY Statement
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
Periodicity runtime parameter Supported
Predefined system variables (i.e., SYSDATE, SYSDAY) Not supported
QUEUETABLE Supported
-m runtime parameter to keep macros Supported
RATE keyword for limiting the rate at which statements are sent to the Teradata Database Supported
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”
Replication Services override Supported
Routing of messages to alternate file Supported via Logger Services
RUN FILE Supported via Teradata PT script language
Schemas, more than one Not supported
Show Version Information Supported
Tenacity Supported
TPump Monitor Interface Not supported
User-defined variables Limited support via script language
Wildcard INSERT Not supported (cannot use “INSERT INTO tablename.*;”)