Setting general options

Use the following procedure to change the general options settings.

  1. From the Primary Menu panel, an object list panel, or a utility panel, type OPTIONS (OPT) on the Command line.
  2. Press Enter.The Options panel is displayed.

  3. In the General options field, type Y.The General Options panel is displayed.

                                  General Options                      1 to 12 of 12
     Command ===>                                                  Scroll ===> PAGE
                                                                                   
     Decimal point. . . . . . . . .  .         Period or comma                      
     SQL string delimiter . . . . .  '         Quote or double-quote                
     Lines per page . . . . . . . .  75        0-199, 0 - unlimited                 
     DB2 feedback size. . . . . . .  64        16-999, Size of feedback area in KB  
                                                                                   
     Truncation chars . . . . . . .  ..        Long name truncation character       
     Truncation position. . . . . .  L         L-Left, M-Middle, R-Right            
     Char field max width . . . . .  30        10-99 For list display               
                                                                                   
     Terse level. . . . . . . . . .  VERBOSE   TERSE/VERBOSE                        
                                                                                   
     Describe Package Explain Only.  N         N/L/A N-No,L-Latest ONLY,A-All       
                                                                                   
                                                                                     
  4. In the Decimal point field, type a period (.) or a comma (,) to use as the decimal point.At startup, Catalog Manager calls the SYSPROC.ADMIN_INFO_SYSPARM stored procedure and sets the Decimal Point value to the character that is set in Db2, either a period or comma. You can change the option only for the current session (for example, for testing or connecting to a different SSID). Catalog Manager defaults to the Db2 setting at the next startup.

  5. In the SQL string delimiter field, type a delimited identifier.The names of Db2 objects can be composed of ordinary identifiers or delimited identifiers. Ordinary identifiers include the letters A through Z, the digits 0 through 9, the three national characters @, #, $, and the underscore character (_). The first character cannot be a digit, and embedded blanks are not permitted. Some SQL keywords might not be ordinary identifiers.

    Delimited identifiers do not follow these rules. Delimited identifiers must be enclosed in SQL escape characters, which are normally double quotation marks ('') but might be set to single quotation marks (') at Db2 installation.

    You can use delimited identifiers for the names of tables, views, aliases, synonyms, columns, and indexes. If you enter an object name that is delimited, Catalog Manager encloses it within the appropriate SQL escape characters. The SQL escape character is specified indirectly. The character that you do not specify as the SQL string delimiter is used as the SQL escape character.

  6. In the Lines per page field, type the maximum number of lines per page on the print data set. Valid values are 0 through 199.
  7. In the DB2 feedback size field, type the amount of KB to provide for Db2 commands. Valid values are 16 through 999.
  8. In the Truncation chars field, type the characters that replace the beginning and end of a truncated string in an object name that is too long to be displayed.

  9. In the Truncation position field, type L, M, or R to specify the location of characters to be omitted in object names that are too long to be displayed.

    To replace characters

    Type

    At the left end (beginning) of the name

    L

    In the middle of the name

    M

    At the right end (end) of the name

    R

  10. In the Char field max width field, type the maximum length of a character column to be displayed. Valid values are 10 through 99. If the actual width of the column name exceeds this value, Catalog Manager truncates the column name accordingly.For more information about customizing list displays, see Customizing-object-list-displays.

  11. In the Terse level field, type TERSE or VERBOSE to indicate the amount of output that you want Catalog Manager to produce in the DDL process.This option is supported only for partitioned table spaces and indexes.

    To produce terse DDL, Catalog Manager requires that all attributes for all partitions match the attributes for the first partition. If any of the attributes are different, Catalog Manager produces verbose DDL.

  12. In the Describe Package Explain Only field, type one of the following values to indicate the level of EXPLAIN(ONLY) information that you want in the report produced by the DESCRIBE PG command.
    This option is supported only for packages.

    To include in the DESCRIBE report

    Type

    No Explain(ONLY) information

    N

    The latest EXPLAIN(ONLY) information

    L

    All the BIND EXPLAIN(ONLY) information accumulated since you last performed a BIND/REBIND with the EXPLAIN(YES/NO) option.

    A

  13. Press END to return to the Options panel.

Related topic

Setting-user-options



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*