Transform name

Name of the transform this name has to be unique in a single pipeline.

Name

The name you want to give a specific data type

Type

A list of the available system data types

system date (variable)

System time, changes every time you ask a date.

system date (fixed)

System time, determined at the start of the pipeline.

start date range (Pipeline)

Start of date range, based upon information in ETL log table. See, also .08 Pipeline Settings.

end date range (Pipeline)

End of date range, based upon information in ETL log table. See, also .08 Pipeline Settings.

start data range (Workflow)

Start of date range based upon information in the ETL log table. See also .08 Pipeline Settings.

End date range (Workflow)

End of date range based upon information in the ETL log table. See also .08 Pipeline Settings.

Yesterday 00:00:00

Start of yesterday.

Yesterday 23:59:59

End of yesterday.

Today 00:00:00

Start of today.

Today 23:59:59

End of today.

Tomorrow 00:00:00

Start of tomorrow.

Tomorrow 23:59:59

End of tomorrow

First day of last month 00:00:00

Start of last month.

Last day of last month 23:59:59

End of last month.

First day of this month 00:00:00

Start of this month.

Last day of this month 23:59:59

End of this month.

First day of next month 00:00:00

Start of next month.

Last day of next month 23:59:59

End of next month.

copy of transform

Copy nr of the transform. See also Launching several copies of a transform.

Pipeline name

Name of the pipeline.

Pipeline file name

File name of the pipeline (XML only).

User that modified the pipeline last

Date when the pipeline was modified last

Hostname

Returns the hostname of the server.

IP address

Returns the IP address of the server.

Current process identifier (PID)

The PID under which the Java process is currently running

JVM max memory

JVM total memory

JVM free memory

JVM available memory

Available processors

JVM CPU time (milliseconds)

Total physical memory size (bytes)

Total swap space size (bytes)

Committed virtual size (bytes)

Free physical memory size (bytes)

Free swap space size (bytes)

First day of last week 00:00:00

Last day of last week 23:59:59

Last working day of last week 23:59:59

First day of last week 00:00:00 (US)

Last day of last week 23:59:59 (US)

First day of this week 00:00:00

Last day of this week 23:59:59

Last working day of this week 23:59:59

First day of this week 00:00:00 (US)

Last day of this week 23:59:59 (US)

First day of next week 00:00:00

Last day of next week 23:59:59

Last working day of next week 23:59:59

First day of next week 00:00:00 (US)

Last day of next week 23:59:59 (US)

First day of last quarter 00:00:00

Last day of last quarter 23:59:59

First day of this quarter 00:00:00

Last day of this quarter 23:59:59

First day of next quarter 00:00:00

Last day of next quarter 23:59:59

First day of last year 00:00:00

Last day of last year 23:59:59

First day of this year 00:00:00

Last day of this year 23:59:59

First day of next year 00:00:00

Last day of next year 23:59:59

Previous workflow action result

Previous workflow action exit status

Previous workflow action nr

Previous workflow action nr errors

Previous workflow action nr lines input

Previous workflow action nr lines output

Previous workflow action nr lines read

Previous workflow action nr lines updated

Previous workflow action nr lines written

Previous workflow action nr lines deleted

Previous workflow action nr lines rejected

Previous workflow action nr rows

Previous workflow action stopped

Previous workflow action nr files

Previous workflow action nr files retrieved

Previous workflow action log text