Runtime Variables

Use runtime variables to parametrize the executables commands or scripts in the Processing tab or to specify archive paths in the Source and Advanced tabs.

Note: These variables must appear inside curly brackets when used. Runtime variables are not SBN expressions and are not evaluated.

The list of supported runtime variables include:

{JobName}
{JobID}
{ProjectName}
{ProjectID}
{ExecutionID}
{Timestamp} – a timestamp values in a format that can be used for directory or file names.

Example: If you want to archive each stage file grouped by time, use:

c:\archive\{Timestamp}
{Target} – name of the current target table.

Example: If you want to archive each stage file grouped by job name and target table name, use:

c:\archive\{JobName}\{Target}\{ExecutionId}

Note: Missing directories are created at runtime.
{Source} – name of the current source table.
{Event} – name of the current event (BeginLoad, EndLoadSuccess, EndLoadError, BeginTable, EndTableSuccess, EndTableError). Only used in the Processing tab.
{TargetOwner} – owner part of a qualified target table name.

Example: USER for a table called USER.CUSTOMER
{TargetTable} – table part of a qualified target table name.

Example: CUSTOMER for a table called USER.CUSTOMER
{SourceOwner} – owner part of a qualified source table name.

Example: USER for a table called USER.CUSTOMER
{SourceTable}– table part of a qualified source table name.

Example: CUSTOMER for a table called USER.CUSTOMER
{ScriptPath} – current script directory. Equivalent to the SBN expression [uSystemFolder('APP_SCRIPT')].