Rational Programming Patterns for System z

SQL complement

In this tab, you complete the description of the -CE lines called in a Segment 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 a selection of subschemas or of the entire table. In a first level call, it will be considered as a table. The Data Elements of the Segments 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 calling Segments 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 have been defined before creating complementary lines.

Characteristics
In this field, you must indicate the nature of the compound characteristics, which are the Ring (A), Reverse (I), Simple reference or referenced (R), Relation (L). These characteristics were initially created in the Pacbase repository but they need to be completed on the complementary lines (-SE lines), in the SOCRATE entity field. Once you have selected a choice in the characteristics field's drop-down list, the value is 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 (blank value),
  • Update (M),
  • Delete (S),
  • Generation (G),
  • Generation and Delete (A).
SOCRATE entity
This field must be used to complete the compound characteristics selected in the Characteristics field. The entity code required 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)