You use this section to enter the generation options of a Relational Database Bock.
To indicate an option, you must enter O in the Type column, and the option in the Description column.
Enter the option's name, followed by the = sign, and the option's value.
To activate an option, enter OPTION=YES (OPTION is the option code).
With this option (COMMA=YES), the punctuation will be automatically generated at the end of the lines on which you have added or modified the characteristics of the Table/View called in the Block.
This 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 VA Pac Constants in comments when generating the Block.
With this option (COMMIT=YES), a COMMIT statement is generated each time an SQL object is cancelled ('DROP'). In the same stream, you can then cancel and re-create the same object.
If you enter this option (PREFIX=NO), the standard prefixing of the Tables' and Views' external names will not apply in this Block.
With this option, an external name which does not include a dot or a prefix will be generated as is, and an external name entered as .NAME will be generated with a prefix which is the user's 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 opion (TIME=YES), Date (with the M format), Time (T format) and Timestamp (TS format) fields will be recognized in NonStop Tandem Blocks whose version number has been left to blank ('Other Systems, all versions').
With this opion (TIME=NO), Date (with the M format), Time (T format) and Timestamp (TS format) fields will be rejected in NonStop Blocks whose version number has been left to blank ('Other Systems, all versions').
With this option (UPPER=NO), lowercase letters will not be converted into uppercase letters upon generation.
With this option (DESCR=ALL), the complete description of the Segments which constitute DB2 Tables will be generated.
All the fields called in the Segments (i.e. their group Data Elements, redefines and occurs) will be 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).