Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Microsoft SQL Server Relational Connections

Microsoft SQL Server Relational Connections

Configure relational connections to extract data from and load data to Microsoft SQL Server sources and targets in bulk data movement sessions. Also use relational connections to apply change data to Microsoft SQL Server relational targets in CDC sessions.
The following table describes the connection attributes for the PWX MSSQLServer relational connection type:
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:
  • APPBUFSIZE=
    app_buf_size.
    Specifies the initial size of the application buffer for the connection. Overrides the APPBUFSIZE statement in the DBMOVER configuration file.
  • CONNECTSTRINGCODEPAGE=
    code_page
    . Code page of the characters in the connection string. Enter this override if PowerExchange issues message PWX-07610.
  • LOWVALUES={Y|
    N
    }. Indicates whether PowerExchange preserves hexadecimal '0' values, called
    low values
    , in source character fields when passing these values to a PowerCenter session. Enter Y to preserve low values. When the session runs, PWXPC can write these values to a VSAM target on z/OS or to a sequential file target on Linux, UNIX, Windows, or z/OS. Overrides the LOWVALUES statement in the DBMOVER configuration file.
  • PWXNOQUOTES={Y|
    N
    }. By default, in the SQL SELECT statements that PWXPC uses to select data for session processing, PWXPC adds double-quotation marks (") around every table name and field name that includes spaces or special characters. These special characters are
    /+-=~`!%^&*()[]{}';?,< >\\|
    . If a table is identified by both a schema name and table name in the format
    schema
    .
    table_name
    , PWXPC places the quotation marks only around the "
    table_name
    " value.
    If for any reason, you cannot use quoted table names or field names in your environment, set PWXNOQUOTES to Y to override the default behavior.
  • RETLOGINFOMSG={
    N
    |Y}. By default, PWXPC writes PowerExchange error and warning messages but not informational messages to the session log. If you specify RETLOGINFOMSG=Y, PWXPC writes informational messages as well as error and warning messages to the session log.
  • TCPIP_OP_TIMEOUT=
    network_operation_timeout
    . A network operation timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.
  • TCPIP_CON_TIMEOUT=
    connection_timeout
    . A connection timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.
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.

0 COMMENTS

We’d like to hear from you!