Etl Configuration Macros - Documentation for Bmc Helix Continuous Optimization 23.3

Etl Configuration Macros - Documentation for Bmc Helix Continuous Optimization 23.3

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 " ").

David Miller
Author

David Miller

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.