16.10 - Syntax - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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-2436).

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.