PowerExchange Interfaces for PowerCenter

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

Back Next

Configuring Sessions to Load Data to Nonrelational Targets

PWXPC can load data to nonrelational targets. Nonrelational target types include Adabas, IMS, sequential data sets, flat files, and VSAM files.

Based on the target type, PowerCenter selects the correct PowerExchange Writer. After you select a PWX NRDB Batch application connection, you can configure session properties for the target.

For information about configuring sessions for multiple-record nonrelational targets, see Multiple-Record Write Session Properties for Targets.

In the Task Developer, double-click the session to edit it.

On the

Mapping

tab, expand the

Targets

node in the

Transformations

tree. Then click a nonrelational target.

PowerCenter sets the writer value based on the selected target type.

Under the

Connections

, in

Value

field, select a PWX NRDB Batch application connection.

Under

Properties

, set the session attributes for the target type, as needed.

The following table describes these attributes in alphabetical order:

Attribute Name	Description
ADABAS Password	For the ADABAS target type, the Adabas file password. If the ADABAS FDT for the target file is password protected, enter the ADABAS FDT password. PowerCenter encrypts the password and displays the encrypted password in the XML file that it generates for the workflow.
BLKSIZE	For the SEQ target type on z/OS, the z/OS data set block size. Default is 0, which means use the best possible block size. If you select VB for the RECFM value, the actual block size might be up to four bytes greater than the value you specify for BLKSIZE .
DATACLAS	For the SEQ target type on z/OS, the z/OS SMS data class name.
Delete SQL Override	For the ADABAS and VSAM target types, overrides the default Delete SQL that is sent to PowerExchange.
Disp	For the SEQ target type on z/OS, the z/OS data set disposition. Valid values: OLD SHR NEW MOD Default is MOD if the data set exists, and NEW if it does not.
File Name Override	For the SEQ and VSAM target types, overrides the data set or file name in the PowerExchange data map. Enter the complete data set or file name. For i5/OS, use the following format: `library_name`/`file_name`.
IMS AM Override	For the IMS target type, overrides the IMS access method in the imported data map for the target with the other allowable access method. The session then uses the override access method at run time. If you imported a target data map that specifies the DL/1 BATCH access method, enter O to override it with the IMS ODBA access method. For ODBA access, you must also specify the IMS PSBNAME Override and IMS PCBNAME Override attributes. If you imported a target data map that specifies the IMS ODBA access method, enter D to override it with the DL/1 BATCH access method, which provides DL/I or BMP access. You must also specify the IMS PCBNUMBER Override attribute. Before you run the session with an access method override, ensure that you complete the PowerExchange configuration tasks for the new access method. For example, if the override is DL/1 BATCH, you must configure LISTENER and NETPORT statements in the DBMOVER member and configure the netport JCL. If the override is IMS ODBA, you must perform other configuration tasks. For more information, see "IMS Data Maps" in the PowerExchange Navigator User Guide .
IMS PCBNAME Override	For the IMS target type, if you imported an IMS ODBA data map for the target and did not override the access method, this value overrides the PCB name from the data map. If you specified ODBA access as an override in the IMS AM Override attribute, you must enter this value. A PCB name is required for ODBA access. A PCB name is not used for DL/I or BMP access.
IMS PCBNUMBER Override	For the IMS target type, if you imported a DL/1 BATCH data map for the target and did not override the access method, this value overrides the PCB number from the data map. If you specified DL/I or BMP access as an override in the IMS AM Override attribute, you must enter this value. A PCB number is required for DL/I or BMP access. A PCB number is not used for IMS ODBA access.
IMS PSBNAME Override	If you imported an IMS ODBA data map for the target and did not override the access method, this value overrides the PSB name from the data map. If you specified ODBA access as an override in the IMS AM Override attribute, you must enter this value. A PSB name is required for ODBA access. If you use DL/I batch or BMP access and specify this override, you must also specify the PSB=%PSBNAME substitution variable in the netport JCL. The override value then replaces the substitution variable in the JCL. If you specify the PSB=%1 substitution variable instead of PSB=%PSBNAME in the netport JCL, the session uses the PSB name in the NETPORT statement, if specified. In this case, you need a separate NETPORT statement for each PSB. To avoid exceeding the limit of ten NETPORT statements, use this override with %PSBNAME substitution variable instead.
IMS SSID Override	For the IMS target type, if you imported an IMS ODBA data map for the target and did not override the access method, use this value to override the IMS subsystem ID (SSID). If you specified ODBA access as an override in the IMS AM Override attribute, you must enter this value. An SSID is required for ODBA access. If you use the IMS DL/1 BATCH access method and a BMP netport job, you can use this override with the %IMSID substitution variable in the netport JCL. This override replaces the substitution variable to specify the IMS SSID to use for the session. By using the substitution variable and override together, you can use the same netport JCL to access multiple IMS environments, such as development, testing, and production environments. An IMS SSID is not required for DL/I batch access to IMS data or for access to an IMS unload file.
Initialize Target	For the VSAM target type, select this option to have PowerExchange allow both inserts and updates into empty VSAM data sets. If this option is not selected, PowerExchange only allows inserts into empty VSAM data sets.
Insert Only	For the ADABAS and VSAM target types, processes updates and deletes as inserts. You must select this option when the target has no keys.
Insert SQL Override	For all nonrelational target types, overrides the default Insert SQL sent to PowerExchange.
LRECL	For the SEQ target type on z/OS, the data set logical record length. This value is ignored if Disp is not MOD or NEW. Default is 256. If you select VB for the RECFM value, specify the maximum number of data bytes in a logical record for LRECL. PowerExchange adds 4 to this value for the record descriptor word (RDW).
Map Name Override	For all nonrelational target types, overrides the target PowerExchange data map name. PWXPC sends the file name that is specified for the source in the mapping unless this name is overridden in the File Name Override attribute.
MGMTCLAS	For the SEQ target type on z/OS, the SMS management class name. This value is ignored if Disp is not MOD or NEW.
MODELDCB	for the SEQ target type on z/OS, the Model DCB for non-SMS-managed GDG data sets. This value is ignored if Disp is not MOD or NEW.
Post SQL	For all nonrelational target types, one or more SQL statements that are executed after the session runs with the target database connection.
Pre SQL	For all nonrelational target types, one or more SQL statements that are executed before the session runs with the target database connection. In certain cases, you must specify the Pre SQL run once per Connection attribute along with the Pre SQL attribute.
Pre SQL run once per Connection	For all nonrelational target types, runs the SQL that you specify in the Pre SQL attribute only once for a connection. Select this attribute in either of the following cases: In the Pre SQL attribute for a session that uses writer partitioning, you specify a SQL statement such as CREATEFILE that can run only once for the session. If you do not select Pre SQL run once per Connection , the session tries to run the statement once for each partition. In the Pre SQL attribute for a session that performs a multiple-record write, you specify a CREATEFILE statement that creates a new generation of a GDG or creates an empty file. If you do not select Pre SQL run once per Connection , the session creates a generation or tries to create a new empty file for each record that the session writes.
Primary Space	For the SEQ target type on z/OS, the primary space allocation, in the units specified in the Space attribute. This value is ignored if Disp is not MOD or NEW. Default is 1.
RECFM	For the SEQ target type on z/OS, the z/OS record format. Valid values are F, V, FU, FB, VU, VB, FBA, and VBA. This value is ignored if DISP is not MOD or NEW.
Schema Name Override	For all nonrelational target types, overrides the schema name in the target PowerExchange data map. PWXPC sends the file name for the source in the mapping unless this name is overridden in File Name Override attribute.
Secondary Space	For the SEQ target type on z/OS, the secondary space allocation, in the units specified in the Space attribute. This value is ignored if Disp is not MOD or NEW. Default is 1.
Space	For the SEQ target type on z/OS, the type of units for expressing primary or secondary space for z/OS data sets. Valid values are: CYLINDER TRACK This value is ignored if Disp is not MOD or NEW. Default is TRACK.
STORCLAS	For the SEQ target type on z/OS, the SMS storage class name. This value is ignored if Disp is not MOD or NEW.
Truncate target option	For the VSAM target type, truncates, or deletes, table contents before loading new data. VSAM data sets must be defined with the REUSE option for this truncate option to function correctly.
UNIT	For the SEQ target type on z/OS, the z/OS unit type. This value is ignored if Disp is not MOD or NEW. Default is SYSDA.
Update SQL Override	For the ADABAS and VSAM target type, overrides the default Update SQL that is sent to PowerExchange.
Upsert	For the ADABAS and VSAM target type, processes failed inserts as updates and updates as inserts.
VOLSER	For the SEQ target type on z/OS, the volume serial number. This value is ignored if Disp is not MOD or NEW.