Corporation Video Gaming Accessories User Manual

Modeling Interactions for OracleAS Adapter for IMS/DB
Installing and Configuring the OracleAS Adapter for IMS/DB 2-37
Combining sequential fields Select Combining sequential fields to combine two or more
sequential fields into one simple field. The following dialog box
opens:
Enter the following information in the Combining sequential
fields screen:
First field name: Select the first field in the table to include
in the combined field
End field name: Select the last field to be included in the
combined field. Make sure that the fields are sequential.
Enter field name: Enter a name for the new combined field.
Flatten group Select Flatten Group to flatten a field that is an array. This field
must be defined as Group for its data type. When you flatten an
array field, the entries in the array are spread into a new table,
with each entry in its own field. The following screen provides
options for flattening.
Do the following in this screen:
Select Recursive operation to repeat the flattening process
on all levels. For example, if there are multiple child fields
in this group, you can place the values for each field into the
new table when you select this option.
Select Use parent name as prefix to use the name of the
parent field as a prefix when creating the new fields. For
example, if the parent field is called Car Details and
you have a child in the array called Color, when a new
field is created in the flattening operation it will be called
Car Details_Color.
Table 2–14 (Cont.) Field Manipulation Screen Commands
Command Description