PowerExchange Interfaces for PowerCenter

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

Back Next

Previewing PowerExchange Nonrelational Source or Target Data

Preview data from nonrelational sources or targets based on the source or target definitions. For DB2, the preview process displays data from the source DB2 table.

To preview data, you must be able to connect to PowerExchange on the source or target system. PowerCenter uses PWXPC to connect to PowerExchange for nonrelational sources or targets.

Select a nonrelational source or target definition in the workspace.

Right-click the source or target definition in the workspace and click

Preview Data.

The

Preview Data

dialog box appears.

Select a

Location

name.

The location names are retrieved from the NODE statements in the dbmover.cfg file on the Designer system. To add locations, add NODE statements to the dbmover.cfg file.

If necessary, enter

Username

and

Password

values.

For PowerExchange sources and targets on i5/OS and z/OS, a user name and password is 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 z/OS, or to connect to sequential source or target files on i5/OS for bulk data movement, 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 128 characters in length when using a PWXPC connection. A passphrase can contain uppercase and lowercase letters, numbers, spaces, and the following special characters:

’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?

The first character is an apostrophe.

On z/OS, a valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.

In the

Schema

field, change the schema name from the data map, if necessary.

In the

Network Timeout

field, enter the number of seconds that must elapse during a network send or receive operation before PowerExchange ends the connection and issues a timeout error message. Default is 180.

Enter the number of rows that you want to preview.

Default is 10. The

Preview Data

dialog box can display up to 500 rows and up to 65,000 columns.

Click Connect
.

The source or target contents appears in the

Preview Data

dialog box.

To view more data, click

To change the number of rows that are displayed, enter another number of rows and click

Refresh

When you are done previewing data, click