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.5
  • 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. Working with templates
  4. Manipulating columns
Go to Feedback
  • Working with FM/Db2
    • FM/Db2 overview
    • System requirements for File Manager for Db2®
    • Getting started with FM/Db2
    • Working with templates
      • Associating a template with a Db2® object
      • Information stored in a template
      • Using templates with non-Db2 data
      • Editing a template
      • Selecting rows
      • Manipulating columns
        • Selecting columns
        • Holding columns on the display when scrolling

          You can hold columns so that they are always displayed regardless of how far you scroll.

        • Changing the sequence of displayed or printed data
        • Changing column attributes

          Attributes are used to determine how to display, print, or create a column.

        • ROWID columns
      • Specifying scrambling options
      • Mapping data
      • Creating a copybook from a File Manager/Db2 Template

        FM/Db2 provides a sample REXX exec (FMN2CPYB) that you can use to create a PL/I or COBOL copybook from a File Manager/Db2 template.

    • 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

Manipulating columns

FM/Db2 offers a number of ways to manipulate columns within rows. Using the Column Selection/Edit panel, you can:

  • Select columns
  • Change the order in which columns are displayed
  • Change column headings
  • Access column attributes panels to change individual column attributes

Related tasks

  • Selecting columns
  • Changing the sequence of displayed or printed data
  • Changing the column heading
  • Changing column attributes

Related references

  • Column Selection/Edit panel
  • Selecting columns
  • Holding columns on the display when scrolling
    You can hold columns so that they are always displayed regardless of how far you scroll.
  • Changing the sequence of displayed or printed data
  • Changing column attributes
    Attributes are used to determine how to display, print, or create a column.
  • ROWID columns
To add feedback about this topic, select the following checkbox:
Generated by <oXygen/> XML WebHelp