Syntax - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The DEFINE JOB statement syntax order is important.



where:

Syntax Element Description
DEFINE JOB Required keyword phrase specifying the beginning of the job definition.
DESCRIPTION 'descriptionString' Optional keyword phrase providing a descriptive comment about the defined job object.
jobName Required internal Teradata PT metadata name of the defined job object. The name does not have to be the same as the file name of the script.
SECONDS

SEC

Optional keyword indicating that the preceding value is expressed in seconds.
MINUTES

MIN

Optional keyword indicating that the preceding value is expressed in minutes.
SET jobVariable = ‘value’ Optional job script specification to set any number of job variables and their default values.

For more information, see the Teradata® Parallel Transporter User Guide, B035-2445.

STEP stepName Required if there are multiple steps. Keyword phrase that names and introduces a job step. The stepName must be unique within the set of names of the steps in the job.
USING CHARACTER SET or USING CHAR SET charsetId Optional keyword phrase preceding the DEFINE JOB statement that specifies the character set to be used for the job.

This specification is needed only if you want to use an extended character set rather than the platform defaults of ASCII or EBCDIC.

The charsetId is the name or code of the extended character set to be used for the job.