Data types

The following data types are available for retrieval from the Kettle environment by using the Get System Info step:

Data Type
Description

system date (variable)

Current system time. Changes each time you request the date.

system date (fixed)

The system time at the start of the transformation.

start date range (Transformation)

Start of date range, based on information in the ETL log table. See Transformation Settings.

end date range (Transformation)

End of date range, based on information in the ETL log table. See Transformation Settings.

start data range (Job)

Start of date range based on information in the ETL log table. See Transformation Settings.

End date range (Job)

End of date range based on information in the ETL log table. See Transformation 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 step

Copy number of the step. See Launching Several Copies of a Step.

Transformation name

The name of the transformation.

Transformation file name

The file name of the transformation (XML only).

User that modified the transformation last

The user name of the last user who modified the transformation.

Date when the transformation was modified last

Date and time when the transformation was last modified.

Transformation batch ID

The ID_BATCH value in the logging table. See Transformation Settings.

Parent job batch ID

The PDI batch ID of the parent job taken from the job logging table. You need to enable logging in the job and set Pass batch ID in the job settings.

Hostname

The hostname of the server.

IP address

The IP address of the server.

Command line argument 1

Argument 1 on the command line.

Command line argument 2

Argument 2 on the command line.

Command line argument 3

Argument 3 on the command line.

Command line argument 4

Argument 4 on the command line.

Command line argument 5

Argument 5 on the command line.

Command line argument 6

Argument 6 on the command line.

Command line argument 7

Argument 7 on the command line.

Command line argument 8

Argument 8 on the command line.

Command line argument 9

Argument 9 on the command line.

Command line argument 10

Argument 10 on the command line.

Kettle version

The Kettle version (for example: 8.1.0).

Kettle Build Version

The build version of the core Kettle library (for example, 27).

Kettle Build Date

The build date of the core Kettle library.

Current process identifier (PID)

The PID under which the Java process is currently running.

JVM max memory

The maximum memory size (in bytes) that the JVM will attempt to use.

JVM total memory

The memory size (in bytes) in the JVM.

JVM free memory

The memory size (in bytes) free in the JVM.

JVM available memory

The memory size (in bytes) that is available for the JVM to use.

Available processors

The number of available processors on this computer system.

JVM CPU time (milliseconds)

The number of milliseconds it takes the JVM’s CPU to complete a clock cycle.

Total physical memory size (bytes)

The memory size (in bytes) available on this computer system.

Total swap space size (bytes)

The memory size (in bytes) in swap space on this computer system.

Committed virtual size (bytes)

The memory size (in bytes) of virtual memory used by the JVM.

Free physical memory size (bytes)

The memory size (in bytes) of free to the computer system.

Free swap space size (bytes)

The memory size (in bytes) free in the swap space on this computer system.

First day of last week 00:00:00

The date of last week’s Sunday.

Last day of last week 23:59:59

The date of last week’s Saturday.

Last working day of last week 23:59:59

The date of last week’s Friday.

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

The date of last week’s Sunday (US time).

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

The date of last week’s Saturday (US time).

First day of this week 00:00:00

The date of this week’s Sunday.

Last day of this week 23:59:59

The date of this week’s Saturday.

Last working day of this week 23:59:59

The date of this week’s Friday.

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

The date of this week’s Sunday (US time)

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

The date of this week’s Saturday (US time).

First day of next week 00:00:00

The date of next week’s Sunday

Last day of next week 23:59:59

The date of next week’s Saturday.

Last working day of next week 23:59:59

The date of next week’s Friday.

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

The date of the next week’s Sunday (US time).

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

The date of next week’s Saturday (US time).

First day of last quarter 00:00:00

The date of the first day of the previous quarter.

Last day of last quarter 23:59:59

The date of the last day of the previous quarter.

First day of this quarter 00:00:00

The date of the first day of the current quarter.

Last day of this quarter 23:59:59

The date of the last day of the current quarter.

First day of next quarter 00:00:00

The date of the first day of the next (upcoming) quarter.

Last day of next quarter 23:59:59

The date of the last day of the next (upcoming) quarter.

First day of last year 00:00:00

The date of the first day of the previous year.

Last day of last year 23:59:59

The date of the last day of the current year.

First day of this year 00:00:00

The date of the first day of the current year.

Last day of this year 23:59:59

The date of the last day of the current year.

First day of next year 00:00:00

The date of the first day of the next (upcoming) year.

Last day of next year 23:59:59

The date of the last day of the next (upcoming) year.

Previous job entry result

A Boolean representing the status of the previous job entry (Y=successful; N=failed).

Previous job entry exit status

An Integer representing the exit status of the previous job entry.

Previous job entry nr

An Integer representing the position of the previous entry in the job flow.

Previous job entry nr errors

The number of errors from the previous job entry.

Previous job entry nr lines input

The number of lines that came into the previous job entry.

Previous job entry nr lines output

The number of lines that were sent out from the previous job entry.

Previous job entry nr lines read

The number of lines that were read during the previous job entry.

Previous job entry nr lines updated

The number of lines that were updated during the previous job entry.

Previous job entry nr lines written

The number of lines that were written during the previous job entry.

Previous job entry nr lines deleted

The number of lines that were deleted during the previous job entry.

Previous job entry nr lines rejected

The number of lines that were rejected during the previous job entry.

Previous job entry nr rows

The number of rows outputted by the previous job entry.

Previous job entry stopped

A Boolean representing whether the previous job entry is stopped or not.

Previous job entry nr files

The number of files that were accessed in the previous job entry.

Previous job entry nr files retrieved

The number of files that were retrieved externally in the previous job entry.

Previous job entry log text

The text log from the previous job entry.

Last updated

Was this helpful?