To display the content of this 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 such as occurs, sort and redefines (optional). 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 group of Data Elements in a Segment, which is a set of Data Elements named elementary Data Elements. You can add up to 99 elementary Data Elements to a group, on nine different levels maximum. A group can include other groups. All elementary elements are then counted to define the group. A group can 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 the combined formats of the elementary Data Elements must still be 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 must add the Data Elements to the group then.
Value | Comments |
---|---|
U | References the access key for a 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 subsystem. |
Values | Comments |
---|---|
U | References a unique key for a DL/1 database. |
M | References a multiple key for a DL/1 database. |
1 - 9 | Secondary index All other values designate a search field. |
Values | Comments |
---|---|
0 - 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 More... to open a wizard in which you indicate the presence check values for the element called in the Segment.
Click -G Lines... to define -GC lines for the element called in the Segment.