Reference > Commands > EL (edit and list)

The form of the EL (edit and list) command is:

EL x [.x ],

The EL (edit and list) command is used in the Data Stage to add 1 to a special variable named $XIERR and perform a L (list) command to list out text and data values.

When an attempt is made to write the current record away to the IDF, the variable $XIERR is checked automatically, and if its value is non-zero, the record is not written away. The output IDF does not contain records for which $XIERR was set (those for which the EL (edit and list) command was executed) nor any for which you have explicitly set $XIERR. The command is usually used to denote an error condition. No other action is taken, except that when the attempt to write a record is inhibited, a message is written to the Report file noting that the attempt has failed and what the current value of $XIERR is. The variable $XIERR is reset to 0 after every WRITE command and at FINISH.

For details of the L (list) command see later section.

See also the earlier CK command section.

If run control parameter INTED is used, EL (edit and list) commands are treated as if they were HOLD commands at execution time.

Examples of EL (edit and list) commands in use:

if $10/n1, el $10,

el 'Record contains rubbish',

if $var/n10..15, el $var1.$var2.'More

rubbish'.$147,