English
  • PowerCenter 10.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Back Next

Using Variables to Specify Session Parameter Files

Using Variables to Specify Session Parameter Files

You can enter a workflow or worklet variable as the session parameter file name. Enter a workflow or worklet variable as the session parameter file name if you configure a workflow to run concurrently and you want to define different parameter and variable values for the sessions in each workflow run instance.
When you define a workflow parameter file and a session parameter file for a session within the workflow, the Integration Service uses the workflow parameter file, and ignores the session parameter file. To use a variable to define the session parameter file name, you must define the session parameter file name and set $PMMergeSessParamFile=TRUE in the workflow parameter file. The $PMMergeSessParamFile property causes the Integration Service to read both the session and workflow parameter files.
For example, you configured a workflow to run two concurrent instances that contains three sessions:
The sessions are s_1, s_2, and s_3.
For the first and second workflow instances, you want the sessions to use the following session parameter files:
Session
Session Parameter File Name
(First workflow run instance)
Session Parameter File Name
(Second workflow run instance)
s_1
s_1Inst1.txt
s_1Inst2.txt
s_2
s_2Inst1.txt
s_2Inst2.txt
s_3
s_3Inst1.txt
s_3Inst2.txt
Create workflow variables to store the session parameter file names. For example, you create user-defined workflow variables $$s_1ParamFileName, $$s_2ParamFileName, and $$s_3ParamFileName. In the session properties for each session, set the parameter file name to a workflow variable:
Session
Session Parameter File Name
in Session Properties
s_1
$$s_1ParamFileName
s_2
$$s_2ParamFileName
s_3
$$s_3ParamFileName
In the workflow parameter file for each workflow instance, set each workflow variable to the correct session parameter file name, and set $PMMergeSessParamFile=TRUE.
If you use a variable as the session parameter file name, and you define the same parameter or variable in both the session and workflow parameter files, the Integration Service sets parameter and variable values according to the following rules:
  • When a parameter or variable is defined in the same section of the workflow and session parameter files, the Integration Service uses the value in the workflow parameter file.
  • When a parameter or variable is defined in both the session section of the session parameter file and the workflow section of the workflow parameter file, the Integration Service uses the value in the session parameter file.