/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
Language
English
Product name
Connect ETL
Title
Connect ETL Data Transformation Language (DTL) Guide
Copyright
2023
First publish date
2003
Last updated
2023-09-11
Published on
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.