-G Lines associated with the description lines of a Database Block

In the -G Lines creation wizard, you can enter generation elements on the -GG lines that are associated with a Database Block description line.

You open this wizard from the -D line definition section of the Database Block description tab (-DR Lines, -DC Lines, or -DH Lines). In this wizard, you can add generation elements on -GG Lines. For the -DR lines, you can also enter comments for the selected description line on -GC Lines.

In the -GG Lines tab, you can modify the information that is indicated in the Block description lines before the generation. Lines are automatically displayed to guide you when you enter the physical information of the Block. These lines are identified by VIRT or GUID in the Source column. These lines are called virtual lines. Only the lines that are identified by VIRT are generated.

To modify these lines, you must override them (Override button) and create lines between the beginning and end insertion lines. When you override these lines, the VIRT and GUID identifiers are changed into FROMVIRT and FromGUID. The lines can then be entered.

You can create lines anywhere in the table by clicking Add.

The table contains the following columns:
Error
This column displays a dot on all the existing description lines that are not empty.

Moreover, if this line is not correct, this column also displays an error or warning symbol, depending on the severity of the error. A hover help indicates the source of the error.

Type
When you click a line in this column, a list is displayed. You must select one of the following values:
  • *: comment lines to be generated,
  • V: lines generated before the automatically generated elements,
  • G: line generated instead of the automatically generated elements,
  • P: lines generated between the automatically generated elements and their descriptions,
  • Z: lines generated after the automatically generated elements.
    Note: P and Z types are available only on the -GG lines that are associated with CODASYL Blocks (Definition and -DC Lines tabs).
Description
This field must be used to enter the generation elements or comments to be generated. Its content depends on the selected Block type and line type.

A free reference is set when you frame a Data Element by the symbols < and >, or enter a Data Element after a dash in this field. This Data Element can be preceded by a Segment.

Content assist is available on this field, as shown by the symbol content assist in front of the field. To activate it, press Ctrl+Space. A subreference link is automatically created, even if the instance does not exist. From the target instance in the subreference results, you can start a super reference search.

You can activate the content assist if you enter < in the first position. The content assist wizard then displays the list of the available Data Elements. You can also specify a Segment 00 and activate the content assist to select a Data Element (<xx00-delco>). The subreference link is created with the Data Element only. If you do not enter < in the first position, you can also activate the content assist after a dash (-) to select a Data Element.

  • For -GG lines associated with a -DC description line:

    You must enter the generation elements or the comments to be generated in the Description column. You can use the virtual lines to specify the physical characteristics of the areas and sets (DMCL), including the information that is related to the sort keys and insertion modes.

  • For -GG lines associated with a -DR description line:

    Virtual lines are automatically generated for each SQL record type (view or index for example) that is described in the Block description lines. You can override these lines to modify the characteristics of a column, insert new lines, or specify the source of a column in a view.

    • To modify the characteristics of a column, you must insert lines between the beginning and end insertion lines. Enter <DELCO> (DELCO is the Data Element) on the first line, then the new description on the following lines.
    • To insert a column into a table, you must use the same technique. You must insert one or more lines between the beginning and end insertion lines.
    • To override the source of a column in a view, you must select the line. Click Override and create one or more lines between the beginning and end insertion lines. To modify the source of a column in a view, create a G type line with the following format: <FFNN-DELCO> (FFNN is the source Segment and DELCO the new Data Element).
  • For -GG lines associated with a -DH description line:
    • Physical DBD:
      The virtual lines that are associated with a description line of a physical DBD retrieve the Segment description in the repository. They do not need to be rewritten. However, you can modify a FIELD description. To do so, insert one or more lines between the beginning and end insertion lines. On the first line, enter the Data Element that corresponds to the FIELD to be modified, framed with < >. You must enter six characters between the delimiters or complete with blanks.
      Example:
       G <DELCO >
       G FIELD NAME=(NUM,SEQ,U),BYTES=7
    • Logical DBD:
      The virtual lines that are associated with a description line of a logical DBD retrieve, for each Segment of the DBD, its name and the name of its parent Segment. You must complete each line by identifying the source of the Segment.
      SOURCE = ((Segment name,DBD name))
    • Index:

      The virtual lines that are associated with the index description retrieve the Segment description in the repository. The information that is required for the description of an index (LCHILD for example) is unavailable. You must then complete the virtual lines.

    • PCB:

      No virtual line is associated with a PCB-type Database Block. You can modify a PCB description through the virtual lines that are associated with the description lines of a PSB that uses this PCB.

    • PSB:
      The virtual lines that are associated with a PSB description retrieve the description of the Segments that constitute the PCB in the repository. You can modify a SENSEG description. To do so, insert one or more lines between the beginning and end insertion lines. On the first line, enter the Segment that corresponds to the SENSEG to be modified, framed with < >. You must enter four characters between the delimiters or complete with blanks. Enter the new SENSEG description on the following lines.
      Example:
       G <CD10>
       G SENSEG NAME=CLCDE,PARENT=COCRD,PROCOPT=G

The existence of a secondary-level -G line is automatically indicated as an asterisk in the Comments column of the table that contains the call lines.


Feedback