In this tab, you complete the description of the -CE lines
called in a Segment 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 a selection
of subschemas or of the entire table. In a first level call, it will
be considered as a table. The Data Elements of the Segments 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 calling Segments 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 have been defined before creating
complementary lines.
- Characteristics
- In this field, you must indicate the nature of the compound characteristics,
which are the Ring (A), Reverse (I), Simple reference or referenced
(R), Relation (L). These characteristics were initially created in
the Pacbase repository but they need to be completed on the complementary
lines (-SE lines), in the SOCRATE entity field.
Once you have selected a choice in the characteristics field's drop-down list, the value is 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 (blank value),
- Update (M),
- Delete (S),
- Generation (G),
- Generation and Delete (A).
- SOCRATE entity
- This field must be used to complete the compound characteristics
selected in the Characteristics field. The
entity code required 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.