Page tree
Skip to end of metadata
Go to start of metadata

The following table lists all the variables that you can use when configuring ETL tasks. Their actual value is substituted every time the ETL task is executed.

List of variables

Macro name

Description

%PIPE

The pipe "|" character.

%LFNAME

The load file name, if defined.

%LSECOF

The load sectioned file name, if defined.

%BYESTM

The month of rundate-2days.

%BYESTD

The day of rundate minus 2days.

%BYESTY

The year of rundate minus 2days.

%YESTM

The month of rundate minus 1day (that is, yesterday's month).

%YESTD

The day of rundate minus 1day.

%YESTY

The year of rundate minus 1day.

%ADAY

The alfa-encoded day of rundate.

%AMONTH

The alfa-encoded month of rundate.

%AHOUR

The alfa-encoded hour of rundate.

%AYEAR

The alfa-encoded year of rundate.

%DAY

The day of rundate.

%MONTH

The month of rudate.

%YEAR

The year of rundate.

%YEAT

The year of rundate, last two digits.

%BYEYT

The year of rundate minus 2days, last two digits.

%YESYT

The year of rundate minus 1day, last two digits (that is, last two digit).

%HOUR

The hour of rundate.

%MINUTE

The minute of rundate.

%SRCID

The source ID.

%DSID

The dataset ID.

%ZPROG

The ZProgressive of the dataset.

%SRCCD

The alfa-encoded source ID.

%DSCD

The alfa-encoded dataset ID.

%DSNAME

The dataset name.

%BASE

The $CPITBASE environment variable (for example, /opt/cpit).

%CURFPREF

The prefix (part before the first underscore "_") of the current file.

%CURFILE

The currently parsed file name.

%CURFEXT

The file extension (everything before the first ".").

%CURFNOEXT

The file name without extension (everything before the first ".").

%CURFSUFF

The file suffix (everything after the last " ").

%CURFNOSUFF

The file name without suffix (everything before the last " ").

1 Comment

  1.