PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5
- All Products
Option
| Description
|
---|---|
Import Record Definitions on a new Data Map
| 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.
|
Import Key Fields/FDT (Adabas Only)
| 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.
|
Use 2-tier names
| 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:
select * from
schema .map_table 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:
select * from
schema .map .table
This option does not affect the naming conventions that the NRDB and NRDB2 data source types use:
|
Network Operation Timeout
| 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.
|
Connection Pool Size
| If you use connection pooling, 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.
|
Retain
| If you use connection pooling, enter the number of seconds to retain an inactive connection in the connection pool before closing it.
|
Insertion Point
| 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:
The specified insertion point is used when you complete one of the following actions:
|
Show Field Offsets
| Select one or both of the following options to indicate the formats in which to display the offset for records in the
Record window:
|
Show Column SQL Type
| 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.
|
Filter Column Names
| Select an option to filter columns in data maps based on column name. Options are:
By default,
Exclude is selected.
|
Column Name
| Enter a column name to use as filter criteria. You can use the following wildcard characters:
By default, PowerExchange excludes all columns with a name that begins with FILLER.
|
Number of Records
| 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.
If a data file is open in a
Data File window, close the data file and associated data map before setting this option. Otherwise, the new option setting does not take effect until the next time you open the window.
|
Display Format
| Select the display format for records in the data file view. Options are:
Default is
Vertical .
If a data file is open in a
Data File window, close the data file and associated data map before setting this option. Otherwise, the new option setting does not take effect until the next time you open the window.
|
Row Test Connection Timeout (Minutes)
| 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.
|