Rational Developer for System z, Version 7.6

-GO Lines

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).

You can enter the following options here:
  • Default punctuation

    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.

  • No default punctuation

    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.

  • No generation of VA Pac Constants in Comments

    Enter this option (COMMENT=NO) to prevent generating the VA Pac Constants in 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 cancelled ('DROP'). In the same stream, you can then cancel and re-create the same object.

  • No standard prefixing

    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.

  • 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 Tandem)

    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').

  • No generation of Date, Time and Timestamp fields NonStop Tandem)

    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').

  • No conversion of lowercase into uppercase

    With this option (UPPER=NO), lowercase letters will not be 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 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).


Terms of use | Feedback

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