Creating DBD complement lines

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

  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 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 (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 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.


Feedback