Rational Programming Patterns

-GO Lines

You use these lines to enter the generation options of a relational Database Block.

Error
This column displays a dot on all the existing description lines which 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

To indicate an option, you must enter O in the Type column, and the option in the Description column.

Enter the option name, followed by the equals sign (=) and the option value.

To activate an option, enter OPTION=YES (OPTION is the option code).

You can enter the following options here:
  • Default punctuation:

    With this option (COMMA=YES), the punctuation is 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.

  • 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 generating the Block.

  • 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 which does not include a dot or a prefix is generated as is. An external name entered as .NAME is generated with a prefix which is the user's 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 et 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 has been left to 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 has been left to 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 which constitute DB2 tables is generated.

    All the fields 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.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)