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 |