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
:
- Enter the TEDIT primary command.
FM/Db2 displays the Column Selection Edit panel.
- On the line for the MIDINIT column, enter
E
in the Cmd field.FM/Db2 displays the Column Attributes panel for the MIDINIT column.
- Type the new heading,
MIDDLE INITIAL
, in the Heading entry field. - Press the Exit function key (F3).
FM/Db2 displays the Column Selection/Edit panel.
- Press the Exit function key (F3) again.
FM/Db2 displays the Template Save panel.
- 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