Rational Programming Patterns for System z

Creating DBD complement lines

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.

About this task

Procedure

  1. 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.
  2. 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 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. 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.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)