The following table lists the operating features and capabilities of the Teradata FastExport utility and indicates whether such features and capabilities are supported by the Export operator.
FastExport Utility Feature | Teradata PT Operator Support |
---|---|
Access Modules | Supported, using the DataConnector operator |
ANSI Date | Supported |
Blocksize Specification | Supported |
Character sets | Supported, using the USING CHARACTER SET clause before the DEFINE JOB statement |
Checkpoint/restart | Supported |
Configuration file | Supported, using the tbuild command line job attribute option (-v) |
DECIMALDIGITS option | Supported |
DISPLAY command | Not supported |
Environment variables | Not supported |
IF-ELSE-ENDIF commands | Not supported |
Indicator mode | Supported, using the DataConnector operator |
INMOD routines | Not supported |
IMPORT command | Not supported |
Maximum/minimum sessions | Supported |
Multiple SQL SELECT statements | Supported, with same layout, not supported with different layouts |
Record formats | Supported, using the DataConnector operator |
Nonindicator mode | Supported, using the DataConnector operator |
Notify | Supported |
OUTFILE option | Supported, using the DataConnector operator |
OUTLIMIT specification | Supported |
OUTMOD routines | Supported, using the FastExport OUTMOD Adapter operator |
ROUTE MESSAGES command | Not supported |
RUN FILE command | Supported by Teradata PT script language |
SET command | Not supported |
Show version information | Supported |
No Spooling | Supported |
SQL SELECT Statement | Supported |
SQL Statements (other such as CREATE TABLE, DROP TABLE, and so on) | Supported, using the DDL operator |
SQL DATABASE Statement | Supported |
SYSTEM Command | Supported, using the OS Command operator |
Tenacity | Supported |
User-defined variables | Limited support via script syntax |