Syntax - Parallel Transporter

Teradata Parallel Transporter Reference

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

Syntax

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.

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.