The transformation language provides built-in variables. Built-in variables return either run-time or system information. Run-time variables return information such as source and target table name, folder name, session run mode, and workflow run instance name. System variables return session start time, system date, and workflow start time.

You can use built-in variables in expressions in the Designer or Workflow Manager. For example, you can use the system variable SYSDATE in a DATE_DIFF function. You can use run-time variables in expressions and in input fields that accept mapping or workflow variables. For example, you can use run-time variable $PMWorkflowRunInstanceName as part of a target output file name. The

PowerCenter Integration Service

sets the values of built-in variables. You cannot define values for built-in variables in a workflow or session parameter file.

You can use built-in variables in expressions. For example, you can use the system variable SYSDATE in a DATE_DIFF function.

The following built-in variables provide run-time information:

The following built-in variables provide system information:

The following table describes where you use built-in variables in the Designer and Workflow Manager: