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 |