16.10 - Job Steps - 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)

This feature allows multiple job operations in a single script to be executed sequentially. For example, the first step can execute a DDL operator to create a target table. The second step can then execute a Load operator to load the target table. This syntax is as follows:

<twb-job-body>::=<metadata definitions> { (<job step>)+ | <executable statement> }

where the following is true:

Syntax Description
<metadata definitions> Non-executable statements, for example:
DEFINE <script object>
<executable statement> The APPLY statement
<job step> Job step consists of the following:
STEP <step name>
'(' <executable statement> ';+' ')'
';'
<step name> A user-defined script identifier