Execute a process

Description

You can use the Execute a process step to execute a shell script on the host where a job will run.

  • The step is similar to the job entry Shell, but can be used in a transformation to execute for every row.

Notes:

Options

The following table provides a description of the options available for the Execute a process step:

Option

Description

Step name

Name of the step; this name has to be unique in a single transformation

Process field

The field name in the data stream that defines the process to start (shell script / batch file to start). Arguments can also be used.

Fail if not success

Checking this option means if the exit status is different than zero the step fails. You can use error handling to get these rows.

Output line delimiter

Without defining a line delimiter, all returned lines are collapsed into a single string with no line delimiters.
This option is available since 5.0 and by default empty for backward compatibility. You can set to any line delimiter and special characters can be set with the format $[value], e.g. $[0D] for CR or $[0D,0A] for CR/LF (since 5.0).

Result fieldname

Specify here the name of the result fieldname (STRING) added to the output stream of the transformation. This field is populated by the output stream (stdout) of the process.

Error fieldname

Specify here the name of the error fieldname (STRING) added to the output stream of the transformation. This field is filled by the error stream (stderr) of the process.

Exit value

Specify here the name of the exit fieldname (INTEGER) added to the output stream of the transformation. This field is filled by the exit output of the process.