The DBD complement tab is located
in the Segment editor. In this window, you can insert additional description
lines such as SQL or SOCRATE lines in the -CE call lines of a Segment
which is used as a relational database.
Before you begin
The
DBD complement tab displays the -CE
lines you have created in the
-CE Lines tab.
If there is no -CE lines in the
-CE Lines tab,
the list in the
DBD complement tab is empty.
You can create only one -SE line or -DBE line for each instance 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 which is used as a View.
Procedure
- Open the DBD complement tab of a Segment.
To do so, select a Segment in the Design Explorer view, and double-click or right-click and select Open in
the menu. Then access its DBD complement tab
from the Overview tab or directly by clicking
the DBD complement tab.
- In the -CE lines definition list,
click an instance called in the Segment and then click the Add
SQL complement to add a -DBE line, or Add SOCRATE
line to add a -SE line. As a result, an SQL line (an
)
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
(type, referenced characteristics, access authorizations for substructures...).
In the -CE lines definition list,
you find menus to copy and paste -CE lines, to display a selection
or all the columns in the list. If you right-click and select Show
columns, it shows a list of all the columns available
for the description lines of the Segments. Check boxes corresponding
to the columns you want to be displayed in the -CE lines
definition list and click OK, then
the columns display in the list is instantly updated.