/SUBJOB - Connect_ETL - 9.13

Connect ETL Data Transformation Language (DTL) Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
ft:locale
en-US
Product name
Connect ETL
ft:title
Connect ETL Data Transformation Language (DTL) Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:01:45.019000

Purpose

To define a Connect ETL subjob.

Format

/SUBJOB [ALIAS alias] subjob_definition [EXECUTIONTAG tag]

where

subjob_definition = FILE file_name

Arguments

file_name The pathname of the Connect ETL job file. For details on specifying a file path, see File Name and Syntax Requirements.
alias

a name you assign to the Connect ETL job, and which you use to refer to the job in other Data Transformation Language options.

The name assigned to the job must adhere to the rules described for an identifier. See File Name and Syntax Requirements.

tag a character string you assign to the Connect ETL subjob that specifies an execution framework on which to run it

Location

The option may appear anywhere in the job definition.

Notes

The same Connect ETL subjob file can be defined multiple times in the job definition.

When specifying multiple instances of the same subjob file in the job, aliases need to be provided to make the job definition unambiguous. For example, if the first instance of a subjob definition does not have an alias, all subsequent definitions must have an alias specified.

Examples

/SUBJOB FILE sort.dxj 
/SUBJOB FILE "process records.dxj" 
/SUBJOB ALIAS agg FILE aggregate.dxj

These options define three Connect ETL subjobs in the job.