SQL complement
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
- Specify the Segment name of the Segment that is considered as a table. Note: If the Key type is not indicated in the -DR Lines of 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 indicated it is a view that is 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 to specify the source of the column.
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, 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.