To display the details of the Segment Call section, you must select a Segment call in the list of called Elements.
For files and databases represented by Segments, you indicate sort
key, occurs and Redefines options in this section. You also access
to the Segment editor tabs.
Note: Keep in mind that a Segment call is considered as an
elementary Data Element.
- Sort key
- This field identifies all data elements that might be used as
control break sort keys, or as access keys to a file, a database or
a Pactables table.
Note: It is highly recommended to dedicate
a Segment to only one type of use. Each data element that may belong
to a sort key must be referenced by a unique alphabetic or numeric
character. It is recommended to reference the indicators by a series
(1, 2, 3 ...). The actual sort sequence will be chosen at the program
level (on the Call of Data Structures (-CD) screen) by sequencing
the characters in the appropriate order.
Don't forget that
the format of key group data elements must have been entered in the
Dictionary or at the segment level.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. |
Note: Sort keys are not allowed on data elements redefining
other data elements.
- Redefines
- The Data Element containing this option redefines the Data Element
of the same COBOL level which precedes it in the Segment description.
If a Data Element which redefines another Data Element is contained
in a group, it is considered to be an elementary Data Element. It
must be taken into account in the calculation of the number of Data
Elements contained in a group (except for DL1 database Segments).
More
Click theMore... button to open a dialog box in which you indicate the presence check
values for the Segment called in the current Segment.
-G Lines
Click the -G Lines... button to optionally define -GC lines, -GE lines, and -GG lines
for the Segment called in the current Segment.
Clicking the buttons in the bottom part of the section, switches
the editor of the Segment called, in the corresponding tabs: