Rational Programming Patterns

SQL complement

In this tab, you complete the description of the -CE lines in a Segment that is used as a relational database.

SQL complement definition

Original table/Segment
Enter the Segment code of the table Segment.
Note: If the Key type is Blank in the -DR lines definition of the -DR Lines tab in the Database Block editor, it is a view, described by -DBE lines. In this case, you can call a Segment that will be considered as a table. All the Data Elements of the Segment will be selected. No -DBE line must be entered. There can be only one level of Segment call.

However, if the Key type is different from Blank, it is a view described by the selection of subschemas or the entire table. In a first level call, it will be considered as a table. The Data Elements of the Segments that are called in the first Segment will be referenced in this table, whatever the nesting level.

Column name
Enter the Data Element code to specify the source of the column. When Segments are called into a view Segment, the system automatically tracks the source of the columns. This field is then dimmed.

SOCRATE complement definition

A SOCRATE entity and its characteristics must be defined before creating complementary lines.

Characteristics
In this field, you must indicate the nature of the compound characteristics: Ring (A), Reverse (I), Simple reference or referenced (R), or Relation (L). These characteristics were initially created in the repository but they must be completed on the complementary lines (-SE lines), in the SOCRATE entity field. Select a value for the characteristics list. This value is then displayed on the -SE line, in the Type column.
Chain
This field is used to identify the rings with a double chain or the referenced rings with a double chain. Check the Double box to specify a double chain choice. When the double choice is checked, you can see that DOUBLE is displayed on the -SE line in the Chain column.
Authorizations
In this field, you indicate the type of access authorizations for each subschema. For each subschema, you can choose between the following access authorizations:
  • Read only (no value),
  • Update (M),
  • Delete (S),
  • Generation (G),
  • Generation and Delete (A).
SOCRATE entity
This field must be used to complete the compound characteristics that are selected in the Characteristics field. The entity required code depends on the type of characteristics you have chosen:
  • For a simple Reference, you must enter the code of the referenced entity,
  • For a Ring reference, enter the entity code followed by the code of the referenced characteristic,
  • For a Reverse, enter the code of the reversed entity,
  • For a characteristic with a Relation type, enter an entity code, followed by an optional characteristic code.

Terms of use | Feedback

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