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 15.1.2
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with FM/Db2
  • FM/Db2 reference
  • Messages
  • Support resources
  • Notices
This version is no longer supported.
View the latest version.
A newer version of this product documentation is available.
View the latest version.
  1. Home
  2. Working with FM/Db2
  3. 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).

  4. Changing data
  • Working with FM/Db2
    • FM/Db2 overview
    • System requirements for File Manager for Db2®
    • Getting started with FM/Db2
    • 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).

      • FM/Db2 editor sessions
      • Specifying the Db2® object you want to view
      • Restricting the data that FM/Db2 loads from Db2®
      • Viewing data in a File Manager/Db2 editor session
      • Handling special data
      • Changing data
        • Installation settings that affect CAPS
        • Changing data by overtyping
        • Changing data with the CHANGE command
        • Changing data using prefix commands
        • Converting data to uppercase
        • "Read-only" views, non-updateable columns
      • Deleting rows
      • Editing related tables
      • Issuing Db2® commands from within a File Manager/Db2 session
      • Handling errors during an Edit session
    • 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

Changing data

In a File Manager/Db2 editor session, you can change data by:
  • Overtyping
  • Using the CHANGE primary command
  • Entering prefix commands in the prefix area next to each row

Related tasks

  • Installation settings that affect CAPS
  • Changing data by overtyping
  • Changing data with the CHANGE command
  • Changing data using prefix commands
  • Installation settings that affect CAPS
  • Changing data by overtyping
  • Changing data with the CHANGE command
  • Changing data using prefix commands
  • Converting data to uppercase
  • "Read-only" views, non-updateable columns

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.

Rate this topic


To add feedback about this topic, select the following checkbox:
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences