Systems Options (1 of 4) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)          FM/Db2 System Options (1 of 4)          Global Settings

 Uppercase Translation:
    Enter "/" to select option
    /  Translate Db2 object names
    /  Translate input SQL statements

 Encapsulation of SQL Identifiers in Double Quotes:
    Use double quotes
    3  1. For Db2 SQL reserved words
       2. For IBM and Db2 SQL reserved words
       3. Always

 More Options:
    Enter "/" to select option
    /  Arbitrary select statements, time display format, template creation
    /  CCSID warning option
    /  Editor choice for viewing output data, members; cancel confirmation

 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F11=NxtPage  F12=Cancel

Translate Db2® object names

Translates Db2® object owner and Db2® object name to uppercase. (The Db2® object location is always translated to uppercase.) The default is selected.

If you do not select this option, the Db2® object owner and Db2® object name remain as entered by the user.

Translate input SQL statements

Translates any free-form SQL statements entered to uppercase. The default is selected.

If you do not select this option, any free-form SQL statements entered remain as entered by the user.

Encapsulation of SQL Identifiers in Double Quotes

The SQL identifiers encapsulated in double quotation marks in SQL statements generated by FM/Db2. You can select one of the following:

• 1. For Db2® SQL reserved words

  If your Db2® objects include column names that are Db2® SQL reserved words, you must enclose these column names in double quotation marks. Use this option to only enclose identifiers that are Db2® SQL reserved words in double quotation marks. Any other identifiers appear in SQL statements without encapsulating double quotation marks. This option is recommended if you are using the SQL primary command (see SQL primary command) to generate and save SQL statements for later use.

• 2. For IBM® and Db2® SQL reserved words

  Use this option to recognize any identifiers that are either a Db2® SQL reserved word, or an IBM® SQL reserved word, and enclose these words in double quotation marks. Any other identifiers appear in SQL statements without encapsulating double quotation marks.

• 3. Always. This is the default setting. This option applies to view, edit, browse, print, copy, import and export functions only and results in all identifiers being enclosed in double quotation marks in SQL statements generated by FM/Db2.

Note:

1. For information about the rules covering the construction of SQL identifiers, see the DB2 for z/OS SQL Reference.
2. In general, you can use any uppercase alphabetic character and three special characters ($, _, and @) in an SQL identifier without special consideration. If your identifier includes lowercase characters, spaces, or other characters, then you must enclose the identifier in double quotation marks. FM/Db2 detects identifiers with lowercase and other unusual characters and encloses these in double quotation marks. This occurs regardless of the encapsulation option selected.
3. The lists of Db2® and IBM® SQL reserved words used by FM/Db2 are the latest available. When connected to an older release of Db2®, if you have selected either options 1 or 2, FM/Db2 might recognize an identifier as a reserved word, even though the identifier is not defined as a reserved word in the earlier release of Db2®.