The DBD complement tab is in the
Segment editor. You can insert more description lines such as SQL
or SOCRATE lines in the -CE call lines of a Segment that is used as
a relational database.
Before you begin
This tab displays the -CE lines of the
-CE Lines tab.
If there are 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 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
the Add SQL complement button (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
(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. Select the 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.