You can also run a database row test to issue PowerExchange Listener commands through the PowerExchange Navigator.

To preview data, you can run a database row test on the following PowerExchange resources:

A database row test accesses data in a data source and displays it in table format in the

Database Row Test Output

window. The results of a data map or extraction map row test indicate that PowerExchange can access data when a bulk data movement operation or a change data extraction runs.

In addition to previewing data for data sources in a database row test, you can use SQL DTLDESCRIBE statements to preview metadata in a data map or an extraction map. Depending on the data source type, you can preview metadata for columns, foreign and primary keys, procedures and procedure columns, records, schemas, and tables. If you preview metadata in the

Database Row Test

dialog box, PowerExchange generates an SQL DTLDESCRIBE statement in the

SQL Statement

box. You can edit this statement.

For information about the DTLDESCRIBE syntax, see the

PowerExchange Reference Manual

.

If you run a database row test to generate restart tokens for PowerExchange change data capture sources, the PowerExchange Navigator displays the generated restart tokens in the

Database Row Test Output

window. You can copy the output from this window to populate the PWXPC restart token file.

If message PWX-01936 is issued during a data row test in the PowerExchange Navigator, no suitable Unicode font is available. In this case, install the file delivered in the PowerExchange install directory and copy it to the Windows Fonts folder.