Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
IBM File Manager for z/OS® User’s Guide and Reference for Db2 Data Version 14.1.21
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with FM/Db2
  • FM/Db2 reference
  • Messages
  • Support resources
  • Notices
  1. Home
  2. Working with FM/Db2
  3. Getting started with FM/Db2
  4. Setting default processing options
  5. FM/Db2 system options (option 0.2)
  • Working with FM/Db2
    • FM/Db2 overview
    • System requirements for File Manager for Db2®
    • Getting started with FM/Db2
      • Starting and exiting FM/Db2
      • Selecting the Db2® subsystem when more than one is available

        On most FM/Db2 panels, the currently connected Db2® subsystem is displayed immediately after the product name.

      • Using the FM/Db2 interface
      • Getting help
      • Setting default processing options
        • System Options (option 0)
        • Print settings (option 0.1)
        • FM/Db2 system options (option 0.2)
        • Job card specifications (option 0.3)
        • Compiler language selection (option 0.4)
        • COBOL compiler specifications (option 0.5)
        • HLASM compiler specifications (option 0.6)
        • PL/I compiler specifications (option 0.7)
        • Temporary Data Set Allocations (option 0.8)
        • Output Data Set Allocations (option 0.9)
        • Trace options (option 0.10)
        • ISPF settings (option 0.11)
        • View and Edit options (options 1 and 2)
        • Utilities (option 3)
        • Print utility options (option 3.1)
        • Copy utility options (option 3.3)
        • Object List Options (option 3.4)
        • Export utility options (option 3.7)
        • Db2® LOAD utility options (option 3.L)
        • Db2® Utility LISTDEF options (option 3.UL)
        • Db2® Utility OPTIONS options (option 3.UO)
        • Db2® Utility TEMPLATE options (option 3.UT)
        • Db2® Unload utility options (option 3.UU)
        • Displaying or editing DBCS characters
      • SAF-rule controlled auditing
    • Working with templates
    • Viewing and changing Db2® data

      To view the contents of a Db2® table or view, use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/Db2 Browse Utility (option B).

    • Creating and dropping Db2® objects
    • Populating a Db2® table with data
    • Copying data
    • Working with lists of Db2® objects
    • Printing
    • Managing Db2® privileges
    • Generating batch JCL for Db2® utility jobs
    • Working with SQL statements
    • Using FM/Db2 functions in batch jobs

      You can perform FM/Db2 functions that can be executed in batch jobs.

    • Interfacing with Db2® Interactive

FM/Db2 system options (option 0.2)

The FM/Db2 system options control such things as the translation of Db2® object names and input SQL statements to uppercase, the use of double quotation marks for SQL identifiers, and the external format for TIME columns.

Related references

  • Systems Options (1 of 4) panel
  • Systems Options (2 of 4) panel
  • Systems Options (3 of 4) panel

Rate this topic


  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences