From the DBD complement tab of the Segment editor, you can insert
description lines such as SQL or SOCRATE lines in the -CE Lines of a Segment
that is used as a relational database.
Before you begin
This tab displays the description lines of the
-CE Lines tab. If the
-CE Lines tab does not contain any lines, the list in the
DBD
complement tab is empty. You can create only one -SE line or -DBE line for each instance
that is called in the Segment. The -SE lines are SOCRATE lines that are used to enter the
description of the Data Elements called in a Segment with SOCRATE characteristics. The -DBE lines
are used to specify the source (tables) of the elements (columns) called into a Segment that is used
as a view.
Procedure
- Open the DBD complement tab of a
Segment.
- In the -CE lines definition list, click an instance that is called in
the Segment. Then, you can click Add SQL complement (or select this action in
the contextual menu) to add a -DBE line. You can also click Add SOCRATE line
to add a -SE line. As a result, an SQL line (
) or a SOCRATE line (
) is created. You can remove a SOCRATE or SQL line but not a -CE line. The -CE lines can be
modified only in the -CE Lines tab.
- When the complement line is created in the -CE lines, a definition
section is highlighted in the tab. For an SQL line, the SQL complement
definition section is used to enter information about the source of the columns for a
view. In the SOCRATE complement definition section, you can enter the SOCRATE
characteristics such as the type, referenced characteristics, or access authorizations for
substructures.
The -CE lines definition list contains a contextual menu. You can copy and
paste lines or display a selection or all the columns in the list. If you right-click and select
Show columns, the list of all the columns is displayed. Select the check
boxes that correspond to the columns that you want to keep and click OK. The
columns display in the list is updated.