Systems Options (2 of 4) panel

Panel and field definitions

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

 Arbitrary SQL Select Statements:
    Editor option
    1 1. Browse
      2. View
      3. Edit

 Display Format for DATE/TIME Columns:
    Time display format                   Date display format
    1  1. ISO (HH.MM.SS)                  _  1. ISO (yyyy-mm-dd)
       2. JIS (HH:MM:SS)                     2. EVR (dd.mm.yyyy)
       3. Db2 DSNHDECP setting               3. USA (mm/dd/yyyy)
                                             4. Db2 DSNHDECP setting

 Catalog Queries and Template Creation:
    Enter "/" to select option
    /  Use uncommitted read when accessing the Db2 catalog
       Retrieve foreign key information when building templates

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

Arbitrary SQL Select Statements

The type of editor that is used when the result table is displayed. The result table is generated by a freeform SQL statement. The default is 1 (Browse).

You can select one of the following options:

Browse

FM/Db2 uses Browse to display the result table. No prefix area is displayed and you cannot change the data.

View

FM/Db2 uses View to display the result table. You can change the data by using editor commands, or by over-typing data. However, the changes cannot be saved to Db2®.

Edit

FM/Db2 uses Edit to display the result table. You can change the data by using editor commands, or by over-typing data. You can possibly save the changes to Db2®. If you choose to disable this option when you install the product, this option might not be available.

Display Format for DATE/TIME Columns

Time display format

The external format for data retrieved from Db2® TIME data type columns. The default for this option is '1' (ISO). You can select one of the following:

• 1. ISO (HH.MM.SS). This is the default format.
• 2. JIS (HH:MM:SS)
• 3. Db2 DSNHDECP setting (uses the external format set in the Db2® DSNHDECP module).
  Depending on the time format used, information can be lost when data is retrieved from Db2® (for example, the USA format, which discards the seconds portion of any time). If LOCAL is specified (a time format exit is in use), ensure that there is no loss of information when the time value is converted to an external format. When you use this option, you can encounter:

  • SQLCODE 100 (row not found) conditions when attempting to delete or update tables that contain a TIME column.
  • Removal of the seconds portion of any TIME column (the seconds value is set to 00) in print, copy, or export operations.

Date display format

The external format for data retrieved from Db2® DATE data type columns. The default for this option is '1' (ISO). You can select one of the following:

• 1. ISO (yyyy-mm-dd). This is the default format.
• 2. EUR (dd.mm.yyyy)
• 3. USA (mm/dd/yyyy)
• 4. Db2 DSNHDECP setting (uses the external format set in the Db2® DSNHDECP module).

This setting applies to data displayed in the editor.

Use uncommitted read when accessing the Db2® catalog

This option ensures that all Db2® catalog accesses for the view, edit, print, copy, export and import functions use the uncommitted read option (that is, no locks are taken against the Db2® catalog). The default is selected.

Retrieve foreign key information when building templates

FM/Db2 stores information about primary keys, indexes and foreign keys in the template for an object. This information is retrieved from the Db2® catalog and stored at template creation time, and can be displayed in a File Manager/Db2 editor session. Retrieval of the foreign key information can result in slow response if an additional index has not been built on the SYSIBM.SYSFOREIGNKEYS catalog table (see the File Manager Customization Guide for details). The default for this option is not selected. When this option is not selected, any templates generated do not contain any foreign key information.