Select this option to run the

Import Copybook

wizard when you add a data map.

Clear this option to not run the

Import Copybook

wizard. Alternatively, clear the

Import Record Definitions

option in the

Name

dialog box in the

Add Data Map

wizard.

Default is selected.

Select this option to run the

Adabas FDT Import

wizard when you add an Adabas data map.

Clear this option to not run the

Adabas FDT Import

wizard. Alternatively, clear the

Import Key Fields/FDT

option on the

Name

dialog box in the

Add Data Map

wizard.

Default is selected.

Indicates the naming convention to use for identifying a table in the SQL that PowerExchange generates when you run a database row test for a data map.

Select this option to use a two-tier naming convention. A two-tier name contains a schema name and map name with an appended table name, in the following format:

Clear this option to use a three-tier naming convention. A three-tier name contains a schema name, map name, and table name, in the following format:

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.

If you use connection pooling, in the first text box, enter the maximum number of connections to PowerExchange Listeners to keep open. The PowerExchange Navigator uses up to this number of open connections for faster processing. If you enter a value greater than zero, verify that the value of MAXTASKS in the DBMOVER file on the PowerExchange Listener machine is large enough to accommodate the maximum number of connections in the pool for the Listener task.

In the second, adjacent text box, enter the number of seconds to retain an inactive connection in the connection pool before closing it.

Select one of the following options to specify the insertion point for adding a field to a record or adding a column to a table:

Before current item
After current item
At End

The specified insertion point is used when you complete one of the following actions:

To add a field to a record, click
Add
Field
.
To add a column to a table, click
Add
Column
.

Select one or both of the following options to indicate the formats in which to display the offset for records in the

Record

window:

Select this option to show the SQL datatypes of the columns that appear for a table in the

Table

window.

Clear this option to hide the column datatypes.

Select an option to filter columns in data maps based on column name. Options are:

Include
. Include columns that match the name pattern that you specify.
Exclude
. Exclude columns that match the name pattern.

By default,

Exclude

is selected.

Enter a column name to use as filter criteria. You can use the following wildcard characters:

Asterisk (*) to represent one or more matching characters.
Question mark (?) to represent a single matching character.

By default, PowerExchange excludes all columns with a name that begins with FILLER.

Enter the maximum number of records that can be displayed at a time in the

Data File

window when you view a data file that is associated with a data map.

Valid values are 1 to 99999. Default is 10.

A very large value can increase PowerExchange Navigator response time and CPU usage.

Select the display format for records in the data file view. Options are:

Default is

Vertical

.

Select this check box to display a prompt when a developer user initiates a database row test. The prompt asks whether to send the executable data map file to the remote location before performing a row test. You can use this preference to allow only the developers who maintain the data maps to send data maps to the remote node, thereby minimizing the risk of overlaying later data maps on the remote node. If offloading is used, the data map must be sent to the remote node. When this option is not selected, no users can send the data map to the remote node, and the data map must exist at the Listener location for the row test.

By default, this check box is selected.

Enter the number of minutes after which a connection to a data source for an active database row test times out. An active database row test is one that is open in the

Database Row Test

dialog box and that has not reached the end-of-file (EOF). When the row test is active, the bottom right corner of the PowerExchange Navigator window displays the time remaining before the timeout is reached. After the timeout is reached, the PowerExchange Navigator disconnects from the data source.

Valid values are 0 to 1440 (24 hours). If you specify 0, no row test timeout is in effect. Default is 15 minutes.

Enter the font height for the row test results. Valid values are 8 to 72 points. Default is 16.

If you ran a row test before changing the row test font height, restart the PowerExchange Navigator for the change to take effect. If you did not run a row test before changing the row test font height, the change takes effect immediately in the PowerExchange Navigator or when you next start the PowerExchange Navigator.