Syntax - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Syntax

Table 7: Export Operator Supported Features 

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.

 

Table 8: Required Syntax for the Export Operator 

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.