Navigator User Guide

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

Back Next

Defining Array Properties in the Table Properties Dialog Box

To define how the elements in an array are displayed in a database row test or mapped to rows and columns in a target table, define options in the

Table Properties

dialog box.

The following table describes the options in the

Table Properties

dialog box that you can use to define arrays:

Option	Description
Column Generation	When you first define a table, PowerExchange names columns by using the field names in the record on which the table is based. However, a special naming convention is used for records that contain fields defined as arrays. If you rename columns after you define the table and you do not want column names to be regenerated, select one of the following options: Apply array format changes . Only changes made to array elements are reflected in the table. Refresh with missing columns . Only new columns are added to the table. Reset to defaults . A new set of columns are generated with the default names derived from the field names. Any changes that you have made are discarded. Remove Hidden Columns . DB2UNLD only. A new set of columns are generated by using the default values of the Hide from Table option for each field.
Fields	Controls how elements in an array or group field are displayed: 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 only 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 are displayed in the Fields list and in the Table Properties dialog box, but not the fields that are displayed in the Database Row Test Output window.
How do you want to handle multiple instances of selected records?	Select one of the following options: New Row . For every element in the array, a new row is displayed or written to the target. Ignore . Second and subsequent elements in the array are not displayed or written to the target. Array . The number of elements specified in the Array list are displayed or written to the target in a single row of output. PowerExchange populates the output row until it is full, and then either ignores subsequent elements or displays a new row with the overflow elements if you select the New Row on Overflow option.
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. For more information about this option, see Multiple Arrays in a Single Input Row. This option is enabled only for a table with an imported COPYLIB with multiple OCCURS clauses.

For an example of how to use these options to define how the elements in an array are displayed or mapped, see Adding a Single-Record Data Map with an Array - Example.

Arrays

Adding a Single-Record Data Map with an Array - Example

Viewing or Editing Properties for a Data Map Table

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal