PowerCenter
- PowerCenter 10.5
- All Products
File Source Options
| Description
|
---|---|
Source File Directory
| Enter the directory name in this field. By default, the Integration Service looks in the service process variable directory, $PMSourceFileDir, for file sources.
If you specify both the directory and file name in the Source Filename field, clear this field. The Integration Service concatenates this field with the Source Filename field when it runs the session.
You can also use the $InputFile Name session parameter to specify the file directory.
|
Source Filename
| Enter the file name, or file name and path. Optionally use the $InputFile Name session parameter for the file name.
The Integration Service concatenates this field with the Source File Directory field when it runs the session. For example, if you have “C:\data\” in the Source File Directory field, then enter “filename.dat” in the Source Filename field. When the Integration Service begins the session, it looks for “C:\data\filename.dat”.
By default, the Workflow Manager enters the file name configured in the source definition.
|
Source Filetype
| You can configure multiple file sources using a file list.
Indicates whether the source file contains the source data, or a list of files with the same file properties. Select Direct if the source file contains the source data. Select Indirect if the source file contains a list of files.
When you select Indirect, the Integration Service finds the file list then reads each listed file when it executes the session.
|
Attribute Name
| Description
|
---|---|
Schema Name Override
| Overrides the schema name in the source PowerExchange data map.
|
Map Name Override
| Overrides the data map name of the source PowerExchange data map.
|
File Name
| For the ADABAS Unload source type, specifies the file name of the unloaded Adabas database.
Required for the ADABAS Unload source type.
|
ADABAS Password
| For the ADABAS source type, the database password.
If the ADABAS FDT for the source 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.
|
Database Id Override
| For the ADABAS and ADABAS Unload source types, overrides the ADABAS Database ID in the PowerExchange data map.
|
File Id Override
| For the ADABAS and ADABAS Unload source types, overrides the Adabas file ID in the PowerExchange data map.
|
DB2 Sub System Id
| For the DB2 Datamaps source type, overrides the DB2 subsystem ID in the PowerExchange data map.
|
DB2 Table name
| For the DB2 Datamaps source type, overrides the DB2 table name in the PowerExchange data map.
|
Unload File Name
| For the DB2 Unload Datasets source type, overrides the DB2 unload file name in the PowerExchange data map.
|
Filter Overrides
| Filters the source data that PowerExchange reads based on specific conditions that you define.
PWXPC adds the filter conditions in a WHERE clause on a SELECT SQL statement and then passes the SQL statement to PowerExchange for processing. You can use any filter condition syntax that PowerExchange supports for NRDB SQL.
For a single-record source, use the following syntax:
For example, the following filter condition selects records where a column called TYPE has a value of A or D:
For a multiple-record source, use one of the following syntax alternatives:
The
group_name syntax limits the SQL query condition to a specific record in a multi-record source definition. If you do not use the
group_name syntax, the SQL query condition applies to all records in the multi-record source definition.
For example, to select only records that contain an ID column value of "DBA" for a multi-record source that has USER1 and USER2 records, specify one of the following SQL query conditions:
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
IMS Unload File Name
| For the IMS source type, an IMS database unload file name. Required if you want to read source data from the backup file instead of from the IMS database. For a multiple-record write to an IMS unload file, required for both the source and target.
|
IMS AM Override
| For the IMS source type, overrides the IMS access method in the imported data map for the source with the other available access method. The session then uses the override access method at run time.
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 SSID Override
| For the IMS source type, if you imported an IMS ODBA data map for the source and did not override the access method, use this attribute to override the IMS subsystem ID (SSID) from the data map for the session. If you specified ODBA access as an override in the
IMS AM Override session attribute, you must enter this value. An SSID is required for ODBA access.
If the session has an IMS unload file source, you can use this override to point to another IMSID statement in the DBMOVER member for the purpose of changing from one DBD library to another DBD library. By using the override, you can switch DBD libraries without editing or adding any IMSID statement and restarting the PowerExchange Listener. For example, use this override to test changes that you made to a DBD library against an unload file.
If you use a netport job with BMP access to IMS, you can use this override with the %IMSID substitution variable in the netport JCL to specify an IMS SSID to use for the session. This override replaces the substitution variable. By using the override with the substitution variable, you can use the same netport JCL to access multiple IMS environments, such as development, test, 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.
|
IMS PSBNAME Override
| For the IMS source type, if you imported an IMS ODBA data map for the source 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 from 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 in the DBMOVER member, use this override with %PSBNAME substitution variable instead.
A PSB name is not used for access to an IMS source unload file.
|
IMS PCBNAME Override
| For the IMS source type, if you imported an IMS ODBA data map for the source 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 batch or BMP access or for access to an IMS unload file.
|
IMS PCBNUMBER Override
| For the IMS source type, if you imported a DL/1 BATCH data map for the source and did not override the access method, this value overrides the PCB number from the data map. If you specified DL/I 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 or for access to an IMS unload file.
|
File Name Override
| For the VSAM Files and Sequential Files source types, overrides the data set or file name in the PowerExchange data map.
Enter the complete data set or file name.
For the i5/OS, the format is:
library_name /file_name .
If you select the
Filelist File check box, enter the name of a filelist file in this attribute. A filelist file is a list of files.
|
Filelist File
| For the VSAM Files and Sequential Files source types, identifies the file that contains a list of files. Select this attribute only if you entered a filelist file in the
File Name Override field.
|
SQL Query Override
| Overrides the SQL query sent to PowerExchange.
PWXPC replaces the default SQL query with the SQL statement that you enter and passes the SQL statement to PowerExchange for processing. You can enter any SQL statement that PowerExchange supports for NRDB SQL.
For example, you can select records from table USER where a column called TYPE has a value of A or D by specifying the following SQL query override:
For a multiple-record source, use the following syntax:
For example, you can select only records with ID column values that contain DBA for a multi-record source with two records called USER1 and USER2 by specifying the following SQL query override:
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
PWX Partition Strategy
| For offloaded DB2 Unload, VSAM Files, and Sequential Files source types, specifies one of the following partitioning strategies:
|
Flush After N Blocks
| For multiple-record sources, specifies the maximum number of block flushes that can occur without any one block being flushed.
For bulk multiple-record sources, by default, PWXPC flushes blocks of data only when the buffers are completely full or at end-of-file. If some record types do not have as much data as others, flushing might not occur often. In this case, the record types might not have data on the target for a long time, thereby blocking flushes on the writer side.
To ensure that buffers for all record types are flushed at a regular interval, define this
Flush After N Blocks session property. This property specifies the maximum number of block flushes that can occur across all record types without any one block being flushed. A value of zero disables this feature and causes flushing to occur only when blocks are full.
Valid values for the property are -1 to 100000.
The default value of -1 works in the following manner:
|
Attribute Name
| Description
|
---|---|
Schema Name Override
| Overrides the source schema name.
|
Map Name Override
| Overrides the source table name.
|
DB2 Sub System Id
| Overrides the DB2 instance name in the PowerExchange data map.
|
Image Copy Dataset
| For DB2 image copy sources, provides the image copy data set name. If not specified and the table is in a non-partitioned table space, the most current image copy data set with TYPE=FULL and SHRLEVEL=REFERENECE is used. If the table is in a partitioned table space, you must specify the
Image Copy Dataset attribute.
|
Disable Consistency Checking
| If cleared for a DB2 image copy source, PowerExchange reads the catalog to verify that the DSN of the specified image copy data set is defined with SHRLEVEL=REFERENCE and TYPE=FULL and is an image copy of the specified table. If the DSN is not defined with these properties, the session fails.
If selected, PowerExchange reads the Image Copy Dataset regardless of the values of SHRLEVEL and TYPE and without verifying that the object ID in the image copy matches the object ID in the DB2 catalog.
|
Filter Overrides
| Filters the source data that PowerExchange reads based on specified conditions.
PWXPC adds filter conditions specified to the WHERE clause on the SELECT SQL statement and passes the SQL statement to PowerExchange for processing. You can use any filter condition syntax that PowerExchange supports for NRDB SQL. For more information, see the
PowerExchange Reference Manual .
For example, you can select records where a column called TYPE has a value of A or D by specifying the following filter condition:
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
SQL Query Override
| Overrides the SQL query sent to PowerExchange.
For DB2 for z/OS data sources, PowerExchange automatically appends FOR FETCH ONLY to SQL SELECT statements. If you include FOR FETCH ONLY in the
Sql Query Override attribute in the
Properties area, the expression is included twice in the SELECT statement. In this case, PowerExchange issues an error.
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
Attribute Name
| Description
|
---|---|
Schema Name Override
| Overrides the schema name in the PowerExchange extraction map.
|
Map Name Override
| Overrides the PowerExchange extraction map name.
|
ADABAS Password
| For the Adabas source type, an Adabas password for the source file.
If the Adabas FDT for the source 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.
|
Database Id Override
| For the Adabas source type, overrides the Adabas database ID in the PowerExchange data map.
|
File Id Override
| For the Adabas source type, overrides the Adabas file ID in the PowerExchange data map.
|
Library/File Override
| For the DB2i5OS Real Time source type, overrides the library and file names in the extraction map.
Specify the full library name and file name in the format:
Alternatively, specify an asterisk (*) wildcard for the library name to retrieve changes for all files of the same file name across multiple libraries.
This attribute overrides the
Library/File Override attribute on the application connection.
|
Source Schema Override
| For the Oracle source type, overrides the source schema name.
|
Filter Overrides
| Filters the source data that PowerExchange reads based on specified conditions.
PWXPC adds filter conditions specified to the WHERE clause on the SELECT SQL statement and passes the SQL statement to PowerExchange for processing. You can use any filter condition syntax that PowerExchange supports for NRDB SQL. For more information, see the
PowerExchange Reference Manual .
For example, you can select records where a column called TYPE has a value of A or D by specifying the following filter condition:
To select change records where columns ID and ACCOUNT have changed, you can use the DTL__CI columns by specifying the following filter condition:
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
SQL Query Override
| Overrides the SQL query sent to PowerExchange.
If you specify both the Filter Overrides attribute and a SQL Query Override attribute that contains a filtering WHERE clause, the resulting SELECT statement contains a WHERE clause that uses the AND operator to associate the Filter Overrides filter conditions with the SQL Query Override conditions. For example:
|
Attribute Name
| Description
|
---|---|
Extraction Map Name
| Required. The PowerExchange extraction map name for the CDC source. You must specify the extraction map name for the relational source.
|
Library/File Override
| Optional. For the DB2i5OS Real Time source type, overrides the library and file names in the extraction map.
Specify the full library name and file name in the format:
Alternatively, specify an asterisk (*) wildcard for the library name to retrieve changes for all files of the same file name across multiple libraries.
This attribute overrides the
Library/File Override value on the application connection.
|
Source Schema Override
| Optional. For the Oracle Change and Real Time source types, overrides the source schema name.
|