Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Built-in Variables

Built-in Variables

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:
  • $PM<SourceName>@TableName, $PM<TargetName>@TableName
  • $PMFolderName
  • $PMIntegrationServiceName
  • $PMMappingName
  • $PMRepositoryServiceName
  • $PMRepositoryUserName
  • $PMSessionName
  • $PMSessionRunMode
  • $PMWorkflowName
  • $PMWorkflowRunId
  • $PMWorkflowRunInstanceName
The following built-in variables provide system information:
  • $$$SessStartTime
  • SESSSTARTTIME
  • SYSDATE
  • WORKFLOWSTARTTIME
The following table describes where you use built-in variables in the Designer and Workflow Manager:
Variable Name
Designer
Workflow Manager
$PM<SourceName>@TableName, $PM<TargetName>@TableName,
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept mapping variables
$PMFolderName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMIntegrationServiceName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMMappingName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept mapping variables
$PMRepositoryServiceName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMRepositoryUserName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMSessionName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept mapping variables
$PMSessionRunMode
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept mapping variables
$PMWorkflowName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMWorkflowRunId
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$PMWorkflowRunInstanceName
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
  • Expressions
  • Input fields that accept mapping variables
  • Input fields that accept workflow variables
$$$SessStartTime
  • Mapping or mapplet filter conditions
  • User-defined joins
  • SQL overrides
  • Mapping or mapplet filter conditions
  • User-defined joins
  • SQL overrides
SESSSTARTTIME
  • Expressions
n/a
SYSDATE
  • Expressions
  • Expressions
WORKFLOWSTARTTIME
n/a
  • Expressions


Updated December 12, 2019