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.

The column heading might change the width of the display column. For example, in Table Browse panel, see how the display changes if you change the heading for the MIDINIT column to the longer heading, MIDDLE INITIAL:

  1. Enter the TEDIT primary command.

    FM/Db2 displays the Column Selection Edit panel.

  2. On the line for the MIDINIT column, enter E in the Cmd field.

    FM/Db2 displays the Column Attributes panel for the MIDINIT column.

  3. Type the new heading, MIDDLE INITIAL, in the Heading entry field.
  4. Press the Exit function key (F3).

    FM/Db2 displays the Column Selection/Edit panel.

  5. Press the Exit function key (F3) again.

    FM/Db2 displays the Template Save panel.

  6. Press the RunTemp function key (F6).

    FM/Db2 displays the data with the new heading.

    Table Browse panel showing width of displayed column changed due to longer heading shows how the change of heading has changed the width of the third column from what it was when originally displayed in Table Browse panel.
    Figure 1. Table Browse panel showing width of displayed column changed due to longer heading
      Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                    Table Browse                        42 rows fetched
 TABLE FMNUSER.EMP                                                  Format TABL
 EMPNO  FIRSTNME     MIDDLE INITIAL LASTNAME        WORKDEPT PHONENO HIREDATE
 #1     #2           #3             #4              #5       #6      #7
 CH(6)  VARCHAR(12)  CHARACTER(1)   VARCHAR(15)     CH(3)    CH(4)   DATE
 PU--+> <---+----1-> -              <---+----1----> <-NF     <-->    <---+---->
 ****  Top of data  ****
 200340 ROY<         R              ALONZO<         E21      5698    05/05/1947
 000340 JASON<       R              GOUNOT<         E21      5698    05/05/1947
 000330 WING<                       LEE<            E21      2103    02/23/1976
 000320 RAMLAL<      V              MEHTA<          E21      9990    07/07/1965
 000100 THEODORE<    Q              SPENSER<        E21      0972    06/19/1980
 200330 HELENA<                     WONG<           E21      2103    02/23/1976
 000090 EILEEN<      W              HENDERSON<      E11      5498    08/15/1970
⋮ 
 Command ===> _____________________________________________________ Scroll PAGE
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel