TPump Utility and the Stream Operator
Table 33 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.
|
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 |
|
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.*;”) |