Job definition file example - Connect_ETL - 9.13

Main Job: J_job.jdtl

/DTL
/FLOW J_subjob.jdtl T_task2_in_job.tdtl
/SUBJOB FILE J_subjob.jdtl
/TASK FILE T_task2_in_job.tdtl
/END

Subjob: J_subjob.jdtl

/DTL
/TASK FILE T_task1_in_job.tdtl
/END

Task1: T_task1_in_job.tdtl

/DTL
/TASKTYPE COPY
/INFILE in_task1_in_job.dat STLF
/OUTFILE out_task1_in_job.dat STLF OVERWRITE
/END

Task2:T_task2_in_job.tdtl

/DTL
/TASKTYPE SORT NODUPLICATE
/INFILE out_task1_in_job.dat STLF LAYOUT r1
/OUTFILE out_task2_in_job.dat STLF OVERWRITE
/KEYS first
/RECORDLAYOUT r1 {first CHARACTER 2, last CHARACTER 5}
/END