PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.3
- All Products
Connection Attribute
| Required
| Description
|
---|---|---|
Name
| Yes
| The name of the relational connection.
|
Code Page
| Yes
| The code page that the PowerCenter Integration Service uses to extract data from the source database.
In Unicode mode, PWXPC uses this code page instead of any code page specification in the PowerExchange dbmover.cfg configuration file.
|
Location
| Yes
| The location of the source or target database as specified in a NODE statement in the PowerExchange dbmover.cfg configuration file.
|
Server Name
| Yes
| The name of the SQL Server instance.
|
Database Name
| Yes
| The name of the SQL Server database.
|
User Name
| Yes
| A user name that can be used to access the database.
|
Password
| Yes
| The password for the specified user name.
|
Environment SQL
| No
| SQL commands that run in the database environment.
|
Compression
| No
| Select this option to compress source data during the PowerCenter session.
|
Encryption Type
| No
| The encryption type. For information about supported encryption types, see
Configuring Encryption and Compression.
Default is None.
|
Encryption Level
| No
| The encryption level. For information about supported encryption levels, see
Configuring Encryption and Compression.
Default is 1.
|
Pacing Size
| No
| The pacing size. For information about setting the pacing size, see
Configuring Pacing.
Default is 0.
|
Interpret as Rows
| No
| Controls whether the pacing size is in number of rows.
|
Convert character data to string
| No
| Controls whether character fields are converted to string fields so that embedded nulls in data are processed as spaces.
By default, this attribute is not selected.
For more information, see
Converting Character Data to Strings.
|
Write Mode
| No
| The write mode. For information about
Write Mode options, see
Configuring Write Mode.
Default is
Confirm Write On .
|
Array Size
| No
| The size of the storage array, in number of records, for SQL Server bulk load operations.
Valid values are from 1 through 5000. Default is 25.
|
Reject File
| No
| Overrides the default prefix of PWXR for the reject file.
PowerExchange creates the reject file on the target machine when
Write Mode is set to
Asynchronous with Fault Tolerance .
Enter PWXDISABLE to prevent creation of the reject files.
|
PWX Override
| No
| PowerExchange connection overrides, separated by a semicolon. You can enter one or more of the following optional overrides:
|
Connection Retry Period
| No
| The number of seconds the PowerCenter Integration Service attempts to reconnect to the PowerExchange Listener after the initial connection attempt fails. If the Integration Service cannot connect to the PowerExchange Listener within the retry period, the session fails.
Default value is 0, which disables connection retries based on this PWXPC connection attribute.
PowerExchange Listener connections to source databases do not have connection resilience.
|