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.
| 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 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.*;”) |