You use these lines to enter the generation options of a relational Database Block.
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.
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.
This column displays a value I on all the Input Aid insertions. This value cannot be selected directly.
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.
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.
Enter this option (COMMENT=NO) to prevent generating the Pacbase constants in the comments when the Block is generated.
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.
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.
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.
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).
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).
With this option (UPPER=NO), lowercase letters are not converted into uppercase letters upon generation.
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.