Table of Contents

Search

  1. Introduction
  2. PowerExchange Client for PowerCenter (PWXPC)
  3. PowerExchange ODBC
  4. PowerExchange Interfaces for PowerCenter Tips
  5. Datatypes and Code Pages
  6. PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Previewing PowerExchange Relational Source or Target Data

Previewing PowerExchange Relational Source or Target Data

Preview data for relational source or target tables based on the source or target relational definitions.
You must be able to connect to PowerExchange on the source or target system. To preview relational data, you must use an ODBC data source to connect to PowerExchange.
  1. Select a relational source or target definition in the workspace.
  2. Right-click the source or target definition in the workspace and click
    Preview Data
    .
    The
    Preview Data
    dialog box appears.
  3. Select an ODBC data source name.
    You can add an ODBC data source by clicking the
    Browse
    button.
  4. If necessary, enter
    Username
    and
    Password
    values.
    For PowerExchange sources and targets on i5/OS or z/OS, a user name and password are required only if connecting to a PowerExchange Listener that is configured with a PowerExchange security setting of SECURITY=(1,
    x
    ) or (2,
    x
    ) in the DBMOVER configuration file.
    To connect to sources or targets on i5/Os or z/OS, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 79 characters in length when using ODBC. A passphrase can contain uppercase and lowercase letters, numbers, spaces, and the following special characters:
    ’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?
    The first character is an apostrophe.
  5. Enter a table owner name.
  6. Enter the number of rows that you want to preview.
    Default is 100. The
    Preview Data
    dialog box can display up to 500 rows and up to 65,000 columns.
  7. Click
    Connect
    .
    The table contents appears in the Preview Data dialog box.
  8. To change the number of rows that are displayed, enter another number of rows and click
    Refresh
    .
  9. When you are done previewing data, click
    Close
    .

0 COMMENTS

We’d like to hear from you!