Using the PowerExchange CallProg Function to Call a User Exit Program

Back Next

Table Properties - Definition

View or edit table definition properties.

Available Records: A list of 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 a record to identify it as the parent record.

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

For IDMS:
To select the system index to use for record retrieval, right-click a record and click
Use System Index
. Then, select the index.
Record Dependencies: A list of 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
.
How do you want to handle multiple instances of selected records?: 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
.
Column Generation: 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 to indicate how to refresh columns in a table after you change field definitions in the record on which the table is based:

Apply array format changes
. If the record on which the table is based contains changed fields that 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 changes that you made to column names in the table.

Remove Hidden Columns
. For DB2UNLD. PowerExchange generates a with the default values of
Hide from Table
for each field.
Fields: Select or clear a field to control how elements in an array or group field appear:

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.
How do you want to handle multiple instances of selected records?: New Row
. A new row appears or is written to the target for every element in the array.

Ignore
. PowerExchange does not display, or write to the target, second and subsequent elements in the array.

Array
. PowerExchange displays, or writes to the target, the number of elements specified in the
Array
list 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.
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 a table with an imported COPYLIB with multiple OCCURS clauses.

Rename Saved Search

Table of Contents

Using the PowerExchange CallProg Function to Call a User Exit Program

Using the PowerExchange CallProg Function to Call a User Exit Program

Table Properties - Definition

Table Properties - Definition