Navigator User Guide

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

Back Next

Table Properties - Definition

View or edit table definition properties.

Table Name: The table name, which is used in the SQL at extraction time.

Maximum length is 128 characters.
Column Generation: Indicates how PowerExchange is to refresh columns in a table after you change field definitions in the record on which the table is based. When you first define a table, PowerExchange derives column names from the field names in the record on which the table is based. However, PowerExchange uses a special naming convention for records that contain fields defined as arrays.

Select one of the following options:

Apply array format changes
. If the record on which the table is based contains changed fields that are defined as arrays, those changes are reflected in the corresponding columns in the table.

Refresh with missing columns
. If the record on which the table is based contains new fields, corresponding columns are added to the table.

Reset to defaults
. PowerExchange resets column names to the corresponding fields names in the record on which the table is based. PowerExchange discards any changed column names in the table.

Remove Hidden Columns
. For DB2UNLD. PowerExchange generates a new set of columns with the default values of
Hide from Table
for each field.
Generate CCK Columns: For IMS. If the record on which the table is based contains concatenated key (CCK) fields, controls whether the table displays columns for the CCK fields.

To display CCK columns in the table, select this option.

To run a database row test on a table that includes CCK columns in the following types of IMS data maps, you must
APF-authorize
the following libraries:

If you use IMS DL/1 batch data maps with BMP for the netport job, you must
APF-authorize
all libraries in the BMP STEPLIB concatenation. Otherwise, PowerExchange issues message PWX-02204 with return code 12.
If you use IMS ODBA data maps, you must
APF-authorize
all libraries in the STEPLIB concatenation of the PowerExchange Listener. Otherwise, PowerExchange abends.

To hide CCK columns from the table, clear this option. If the record on which the table is based contains CCK fields, you are prompted to confirm that you want to hide CCK columns.
Available Records: Lists the records in the data map that are not in the complex table.

To add a record to the
Record Dependencies
list, in the
Available Records
list, right-click a record and click
Add Record
.

To add a child record to a parent record:

In the
Record Dependencies
list, select the parent record.

In the
Available Records
list, right-click a record and click
Add Record as Child
. The record moves to the
Record Dependencies
list as a child record of the parent record.

For IDMS, you can select the system index to use for record retrieval. Right-click a record and click
Use System Index
. Then, select the index.

For Datacom, to add a record to the
Record Dependencies
list, right-click a record in the
Available Records
list, and select one of the following commands:

Add Record Using Table Read Sequence > Physical Sequential
. Adds a record to the data map. To retrieve data, the access method calls the Datacom GETPS routine, which retrieves records by physical sequence. However, for queries that include a WHERE clause with a key, the access method uses index sequential access.
Add Record Using Table Read Sequence > Index Sequential
. Adds a record to the data map. To retrieve data, the access method calls the Datacom GETIT routine, which retrieves records by using an index.

Default is
Physical Sequential
.
Record Dependencies: Lists the records that are in the complex table, with any defined hierarchical dependencies.

To remove a record dependency, right-click a record and click
Delete
.

For IDMS, to reverse the direction of the area read, right-click a record and click
Reverse Area Read
. To reverse the direction of the set read, right-click the record and click
Reverse Set Read
.

For Datacom, to change the table read sequence, right-click a record in the
Available Records
list, and select one of the following commands:

Table Read Sequence > Physical Sequential

Table Read Sequence > Index Sequential
How do you want to handle multiple instances of selected records?: Controls how rows appear in the database row ouput or are written to the target.

Select one of the following options:

New Row
. A new row appears or is written to the target for every instance of the record or segment.

Ignore
. Second and subsequent instances of a record or segment appear or are written to the target.

Array
. The number of records or segments specified in the
Array
list appear or are written to the target in a single row of output.

PowerExchange populates the output row until it is full, and then completes one of the following actions:
If you clear the
New Row on Overflow
option, PowerExchange ignores subsequent records or segments.
If you select the
New Row on Overflow
option, PowerExchange displays a new row with the overflow records or segments.

For example, for a record with five instances, if you enter 3 in the
Array
list, PowerExchange builds two output rows. The first row contains an array of three instances, and the second row contains an array of two instances.

If you set a parent record or segment to
Array
, you must set all child records or segments to
Ignore
.
Fields: Controls how elements in an array or group field appear in the database row output or are written to the target.

Select one of the following options:
To display each element in an array or group field in a single row, select the field.
To display each element in an array or group field in a separate row, clear the field.
To display fields defined as a group field or as an array in the
Fields
list, select the
Groups and Arrays only
option. To display all fields in the record in the Fields list, clear this option. This option controls the fields that appear in the
Fields
list and in the
Table Properties
dialog box, but not the fields that appear in the
Database Row Test Output
window.
Multiple Arrays in a Single Input Row: Generates multiple output rows from a single record that contains multiple arrays, or OCCURS clauses. PowerExchange sets the output fields to NULL when the data in the record is exhausted.

Enabled for tables with an imported COPYLIB with multiple OCCURS clauses.