ETL configuration macros
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 " "). |
Comments
Log in or register to comment.