Creating DBD complement lines

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

  1. Open the DBD complement tab of a Segment.
  2. 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 SQL line) or a SOCRATE line (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.
  3. 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.


Feedback