PowerExchange Interfaces for PowerCenter

10.5.2
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Variables for Session and Connection Properties

You can use variables to assign values to properties in the Designer and Workflow Manager and to override some service and service process properties.

You can also use variables to override PWXPC session properties. You can also use variables to override source or target relational or application connection attributes other than PWXPC connection attributes.

PWXPC variables must begin with $PWX or $$.

The following table lists the PWXPC session source and target properties for which you can specify variables:

Session Property	Source or Target Type
DATACLAS	MVS sequential file sources and targets
DB2 Sub System Id	DB2 image copy and DB2 data map sources
DB2 Table name	DB2 data map sources
Delete SQL override	Nonrelational targets
Extraction Map Name	Change data capture sources
File Name Override	VSAM and sequential sources and targets
Filter Overrides	All sources
Image Copy Dataset	DB2 image copy sources
IMS Unload File Name	IMS sources
Insert SQL override	Nonrelational targets
Map Name Override	All sources and nonrelational targets
MGMTCLAS	MVS sequential file sources and targets
MODELDSCB	MVS sequential file sources and targets
Post SQL	Nonrelational targets
Pre SQL	Nonrelational targets
Schema Name Override	All
Source Schema Override	Relational change data capture sources and DB2 image copy
Sql Query Override	All sources
STORCLAS	MVS sequential file sources and targets
UNIT	MVS sequential file sources and targets
Unload File Name	Adabas and DB2 unload file sources
Update SQL override	Nonrelational targets

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Variables for Session and Connection Properties

Variables for Session and Connection Properties