-GO Lines
You use these lines to enter the generation options of a relational Database Block.
- Click Add or select this action in the contextual menu to indicate a generation option. Click in the Type column and select the O line type, then enter the generation option in the Description column. You can also add a comment line
- Click Add an Input Aid call or select this action in the contextual menu to insert
an Input Aid call. A selection box opens. It displays the available
Input Aids that have an O:
Generation options type. Select one of them and click OK.
The variable labels and the symbolic values that are indicated in the selected Input Aid -D Lines tab are then displayed in the Description column, in a read-only mode. The Input Aid name is displayed in the Input Aid column.
If you click the Input Aid name in the Input Aid column, a button is displayed. Click it to see all the Input Aid description lines in a detail window. In this window, you can modify the variable labels and the symbolic values.Note: The length of a variable label cannot exceed the length that is defined in the Input Aid -D Lines tab.
- 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
- You can select one of the following values:
- O: Generation option line,
- *: Line to insert a comment or an override. It will not be generated.
This column displays a value I on all the Input Aid insertions. This value cannot be selected directly.
- Description
- This column must contain the following information:
- If you inserted an O type line, you must enter the option name followed by the equals sign (=) and the option name. To activate an option, enter OPTION=YES (OPTION is the option code)
- If you inserted a * type line, you must enter the comment.
- If you inserted an Input Aid call line, the variable labels and the symbolic values that are indicated in the selected Input Aid -D Lines tab are displayed.
- Input Aid
- This column contains the name of a called Input Aid. If you click the button that is displayed when you click in this column, you can see the Input Aid description in a detail window. In this window, you can modify the variable labels and symbolic values.
List of the generation options
- Default punctuation:
With this option (COMMA=YES), the punctuation is automatically generated at the end of the lines on which you added or modified the characteristics of the Table/View called in the Block.
- No default punctuation:
This option is the default option of all the SQL Blocks, except DB2 SQL, SQL/DS, and ORACLE V5.
With this option (COMMA=NO), you must enter the punctuation when you add or modify the characteristics of columns in the -GG Lines of the Table/View called in the Block.
- No generation of the Pacbase constants
in the comments:
Enter this option (COMMENT=NO) to prevent generating the Pacbase constants in the comments when the Block is generated.
- Generation of COMMIT statements:
With this option (COMMIT=YES), a COMMIT statement is generated each time an SQL object is canceled (DROP). In the same stream, you can then cancel and create the same object again.
- No standard prefixing:
If you enter this option (PREFIX=NO), the standard prefixing of the external names of Tables and Views does not apply in this Block.
With this option, an external name that does not include a dot or a prefix is generated as is. An external name that is entered as .NAME is generated with a prefix that is the user code.
- Return code set to 06:
With this option (RETCOD=06), the return code is set to 06 instead of 08 when errors are detected upon the Block generation. The generation sequence does not stop and goes to the next step.
- Generation of date, time, and timestamp fields (NONSTOP SQL, and
TANDEM):
With this option (TIME=YES), date (with the M format), time (T format) and timestamp (TS format) fields are recognized in NONSTOP SQL and TANDEM Database Blocks whose version number was left blank (Other systems, all versions).
- No generation of date, time, and timestamp fields NONSTOP SQL,
TANDEM):
With this option (TIME=NO), date (with the M format), time (T format) and timestamp (TS format) fields are rejected in NONSTOP SQL Database Blocks whose version number was left blank (Other systems, all versions).
- No conversion of lowercase into uppercase:
With this option (UPPER=NO), lowercase letters are not converted into uppercase letters upon generation.
- Complete description of a DB2 table:
With this option (DESCR=ALL), the complete description of the Segments that constitute DB2 tables is generated.
All the fields that are called in the Segments (their group Data Elements, redefines, and occurs) are generated in the WORKING-STORAGE SECTION.
This option is also required to break down dates into elementary fields for DB2 Segments. The BREAKDATE=YES option must be indicated on the -GO Lines of the Library, Program, or Dialog.