dmexpress Command - 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

Tasks are run when Connect ETL is invoked at the command prompt via one of the following Connect ETL execution commands:

  • Dmxjob - When Connect ETL is invoked via dmxjob, a job definition file, which references a task definition file or files, serves as an argument to /run.
  • Dmexpress - When Connect ETL is invoked via dmexpress, a task definition file serves as an argument to /run. The task is tested independently of a comprehensive Connect ETL job run.

Statistics

To test a task independently of a comprehensive Connect ETL job run, invoke Connect ETL at the command line with dmexpress followed by /run:
dmexpress [optional_task_execution_command_options] /run <task_file>

To reference the available task definition command options, see Connect ETL Task Definition Command Options. For additional information on the dmexpress command, see Running a task from a command prompt in the Connect help.

Task execution statistics are written to the task log by default. For information on controlling the statistics, status, taskid, and task documentation information written to the task log, see /LOGOPTIONS.

dmexpress Completion Status

The value of the exit status value indicates the completion status of dmexpress.

0 Connect ETL completed successfully.
1 dmexpress detected an out-of-sequence record.
100 dmexpress completed but the generated output may be incorrect or incomplete.
111 dmexpress terminated prematurely.