Syntax
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 Teradata 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 |
Teradata SQL SELECT Statement |
Supported |
SQL Statements (other such as CREATE TABLE, DROP TABLE, etc.) |
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 |
Use the following specifications and attributes to the Export operator in a Teradata PT job script.
Specification |
Description |
TYPE |
Operator type. Always EXPORT for the Export operator. |
UserName |
Operator attribute providing the name of the user for the Export operator logon sessions. |
UserPassword |
Operator attribute providing the password associated with the user name. |
SelectStmt |
Operator attribute providing the Teradata SQL SELECT statement for the Export operator job. |