ETL configuration macros - Documentation for BMC TrueSight Capacity Optimization 20.02
Michael Hansen 
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 " ").
