Home
Working with FM/Db2
Working with templates
Manipulating columns
Changing column attributes
Attributes are used to determine how to display, print, or create a column.

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.
      - Changing the attributes for an alphanumeric column
        Enter E in the Cmd field for an alphanumeric column to display the Column Attributes panel. Use this panel to change the heading or width of an alphanumeric column, or to set the pattern if you are creating alphanumeric columns.
      - Changing the attributes for a numeric column
        Enter E in the Cmd field for a numeric column to display the numeric Column Attributes panel. Use this panel to change the heading or display attributes of a numeric column, or to set the pattern if you are creating numeric columns.
    - 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

Changing column attributes

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

To change a column attribute, use the Column Selection/Edit panel and enter E in the Cmd field against one or more columns. For each column you select, FM/Db2 displays a Column Attributes panel.

The attributes you can change are:

Column heading
Output width
Whether to show leading zeros (numeric columns)
Values to use for creating new columns

Note:

For numeric, DATE, TIME, and TIMESTAMP columns, you can change the column heading as for an alphanumeric column.
For DATE, TIME, and TIMESTAMP columns, you can change the output width as for an alphanumeric column.
For very long columns, change the display width to a smaller value to see more data on the display.

Related tasks

Related references