To display the content of the Group definition section, you must select a group call in the list of called Elements. A group is a set of elementary Data Elements. In the Group definition section, you indicate the name and label of the group, and other options to define such as occurs, sort and redefines (optional). Don't forget to click More for a complete definition of the group. You can also define or modify the -G lines of the group from this section.
You can call a Data element group, which is a set of Data elements named Elementary data elements. You can add up to 99 elementary data elements to a group, on 9 different levels maximum. A group may include other groups. All elementary Elements are then counted to define the group. A group may also include one or more Segments. Each Segment called in a group is considered as an Elementary data element. The group Data element can be defined at the Repository level. If so, its length is automatically recalculated (sum of the lengths of the elementary data elements) regardless of its Repository format. If the group is used as a key (sort key or access key), then its format combined with the elementary data elements' must be still compatible with the format you have indicated for the group. When you create a group, it does not contain any elementary data element, it is empty, you need to add the data elements in the group then.
Value | Comments |
---|---|
U | References the access key for a VisualAge Pacbase table. This value must be indicated on the group data element if it is a group key. |
S | Indicates that the data element belongs to at least one sub-system. |
Values | Comments |
---|---|
U | References a unique key for an DL/1 database. |
M | References a multiple key for an DL/1 database. |
1 to 9 | Secondary index All other values designate a search field. |
Values | Comments |
---|---|
0 to 9 | AS400 physical file key. Relational databases |
V | Variable length column |
Blank | Fixed length column |
W | For DB2 SQL, SQL/DS and ORACLE, generation of a variable length column (VARCHAR). |
L | For DB2 SQL, SQL/DS and ORACLE, generation of a LONG VARCHAR. |
Click the More... button to open a wizard in which you indicate the presence check values for the Segment called in the Segment.
Click the -G Lines... button to define -GC lines, -GE lines, and -GG lines for the Segment called in the Segment.