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.
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 output width

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 column heading
        By default, FM/Db2 uses the column name defined in the Db2® catalog as the column heading. You can change this by editing the template and specifying an alternative column heading in the Heading entry field.
        Changing the output width
      - 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 the output width

To change the output width, enter the new width into the Output width entry field.

The output width is the number of character positions used by view, edit, browse, and print panels to show the column in TABL display or print format. The default output width is the maximum of the number of characters needed to show the column heading (or column name, if no heading is specified), and the number of characters needed to show the value of the column, as determined from the column definition in the copybook.

The minimum width is six characters. The maximum is 30 or the column width + 10 (whichever is the greater).

Related references

Column Attributes panel (alphanumeric)

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.