Job steps - Connect_ETL - 9.13

Connect ETL DMXMFJCL User 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 DMXMFJCL User Guide
Copyright
2023
First publish date
2003
Last updated
2023-09-11
Published on
2023-09-11T19:02:58.140000

For most job steps in your JCL, you should be able to build a single Connect ETL task that performs the same set of functions. However, certain combinations of functions are not supported in Connect ETL. For example, it is not possible to join and summarize in a single Connect ETL task. It is also not possible to sort joined data on any field(s) other than the join field(s) in Connect ETL. For these types of job steps, you will need to create two tasks and connect them together in a Connect ETL job.

Note that you can use files as intermediate data sets between tasks in a job while testing the job and switch over to an in-memory connection (called a direct data flow) for the production environment or high-volume testing. In order to connect the target of one task to the source of another, the source file name in the second task must match the target file name in the first task. In order for the job to run correctly, the encodings and record types of the two files must also match. For more information on sources and targets in tasks that are part of a job, see the Data Sets (Sources and Targets) section below.