/TASK - 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 task.

Format

/TASK [ALIAS alias] task_definition [EXECUTIONTAG tag]

where

task_definition = FILE file_name

Arguments

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

a name you assign to the Connect ETL task, 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 task 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 task file can be defined multiple times in the job definition.

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

Examples

/TASK FILE sort.dxt
/TASK ALIAS join_task FILE "c:/files/join records.dxt"
These options define Connect ETL tasks in the job.
/TASK FILE aggregate.dxt ALIAS agg

The task alias can also be specified after the FILE argument.