With 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. To edit a line, select it and press the
F2 key.
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:
- 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.
- 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