In this tab, you complete the description of the -CE lines
in a Segment that is used as a relational database.
SQL complement definition
- Original table/Segment
- Enter the Segment code of the table Segment.
Note: If the
Key
type is
Blank in the
-DR lines definition
of the
-DR Lines tab in the Database Block
editor, it is a view, described by -DBE lines. In this case, you can
call a Segment that will be considered as a table. All the Data Elements
of the Segment will be selected. No -DBE line must be entered. There
can be only one level of Segment call.
However, if the Key
type is different from Blank, it is a
view described by the selection of subschemas or the entire table.
In a first level call, it will be considered as a table. The Data
Elements of the Segments that are called in the first Segment will
be referenced in this table, whatever the nesting level.
- Column name
- Enter the Data Element code to specify the source of the column.
When Segments are called into a view Segment, the system automatically
tracks the source of the columns. This field is then dimmed.
SOCRATE complement definition
A SOCRATE
entity and its characteristics must be defined before creating complementary
lines.
- Characteristics
- In this field, you must indicate the nature of the compound characteristics: Ring
(A), Reverse (I), Simple reference
or referenced (R), or Relation (L). These
characteristics were initially created in the repository but they
must be completed on the complementary lines (-SE lines), in the SOCRATE
entity field. Select a value for the characteristics list.
This value is then displayed on the -SE line, in the Type column.
- Chain
- This field is used to identify the rings with a double chain or
the referenced rings with a double chain. Check the Double box
to specify a double chain choice. When the double choice is checked,
you can see that DOUBLE is displayed on the
-SE line in the Chain column.
- Authorizations
- In this field, you indicate the type of access authorizations
for each subschema. For each subschema, you can choose between the
following access authorizations:
- Read only (no value),
- Update (M),
- Delete (S),
- Generation (G),
- Generation and Delete (A).
- SOCRATE entity
- This field must be used to complete the compound characteristics
that are selected in the Characteristics field.
The entity required code depends on the type of characteristics you
have chosen:
- For a simple Reference, you must enter the code
of the referenced entity,
- For a Ring reference, enter the entity code followed
by the code of the referenced characteristic,
- For a Reverse, enter the code of the reversed
entity,
- For a characteristic with a Relation type, enter
an entity code, followed by an optional characteristic code.