Jump to main content
HCL Logo Product Documentation
Customer Support Software Academy Community Forums
HCL Z Data Tools User’s Guide and Reference for Db2 Data Version 1.1.2
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with ZDT/Db2
  • ZDT/Db2 reference
  • Messages
  • Notices
  1. Home
  2. Working with ZDT/Db2
  3. Viewing and changing Db2® data

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

  4. Changing data
  • Working with ZDT/Db2
    • ZDT/Db2 overview
    • System requirements for Z Data Tools for Db2®
    • Getting started with ZDT/Db2
    • Working with templates
    • Viewing and changing Db2® data

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

      • ZDT/Db2 editor sessions
      • Specifying the Db2® object you want to view
      • Restricting the data that ZDT/Db2 loads from Db2®
      • Viewing data in a Z Data Tools/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 Z Data Tools/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 ZDT/Db2 functions in batch jobs

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

    • Interfacing with Db2® Interactive

Changing data

In a Z Data Tools/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

Rate this topic


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