TABL display format

In TABL display format (the default format), the rows of the table are presented formatted into columns displayed horizontally across the panel.

View panel in TABL display format (with all optional lines displayed) shows an example of a view display in TABL display format.

Figure 1. View panel in TABL display format (with all optional lines displayed)
  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                    Table View                    42 rows fetched
 TABLE FMNUSER.EMP                                                  Format TABL
 EMPNO  FIRSTNME     MIDINIT LASTNAME        WORKDEPT PHONENO HIREDATE   JOB
 #1     #2           #3      #4              #5       #6      #7         #8   +
 CH(6)  VARCHAR(12)  CH(1)   VARCHAR(15)     CH(3)    CH(4)   DATE       CH(8)
 PU--+> <---+----1-> -       <---+----1----> <-NF     <-->    <---+----> <---+-
 ****  Top of data  ****
 000010 CHRISTINE<   I       HAAS<           A00      3978    01.01.1965 PRES
 000020 MICHAEL<     L       THOMPSON<       B01      3476    10.10.1973 MANAGE
 000030 SALLY<       A       KWAN<           C01      4738    05.04.1975 MANAGE
 000050 JOHN<        B       GEYER<          E01      6789    17.08.1949 MANAGE
 000060 IRVING<      F       STERN<          D11      6423    14.09.1973 MANAGE
 000070 EVA<         D       PULASKI<        D21      7831    30.09.1980 MANAGE
 000090 EILEEN<      W       HENDERSON<      E11      5498    15.08.1970 MANAGE
 000100 THEODORE<    Q       SPENSER<        E21      0972    19.06.1980 MANAGE
 000110 VINCENZO<    G       LUCCHESI<       A00      3490    16.05.1958 SALESR
 000120 sean<                O'CONNELL<      A00      2167    05.12.1963 CLERK
 000130 DOLORES<     M       QUINTANA<       C01      4578    28.07.1971 ANALYS
 000140 HEATHER<     A       NICHOLLS<       C01      1793    15.12.1976 ANALYS
 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

Edit panel in TABL display format (with all optional lines displayed) shows an example of an edit display in TABL display format.

Figure 2. Edit panel in TABL display format (with all optional lines displayed)
  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                     Table Edit                         42 rows fetched
 TABLE FMNUSER.EMP                                                  Format TABL
 EMPNO  FIRSTNME     MIDINIT LASTNAME        WORKDEPT PHONENO HIREDATE
        #1     #2           #3      #4              #5       #6      #7
        CH(6)  VARCHAR(12)  CH(1)   VARCHAR(15)     CH(3)    CH(4)   DATE
 000000 ****  Top of data  ****
 000000 ****  Top of data  ****
 000001 000010 CHRISTINE<   I       HAAS<           A00      3978    01.01.1965
 000002 000020 MICHAEL<     L       THOMPSON<       B01      3476    10.10.1973
 000003 000030 SALLY<       A       KWAN<           C01      4738    05.04.1975
 000004 000050 JOHN<        B       GEYER<          E01      6789    17.08.1949
 000005 000060 IRVING<      F       STERN<          D11      6423    14.09.1973
 000006 000070 EVA<         D       PULASKI<        D21      7831    30.09.1980
 000007 000090 EILEEN<      W       HENDERSON<      E11      5498    15.08.1970
 000008 000100 THEODORE<    Q       SPENSER<        E21      0972    19.06.1980
 000009 000110 VINCENZO<    G       LUCCHESI<       A00      3490    16.05.1958
 000010 000120 sean<                O'CONNELL<      A00      2167    05.12.1963
 000011 000130 DOLORES<     M       QUINTANA<       C01      4578    28.07.1971
 000012 000140 HEATHER<     A       NICHOLLS<       C01      1793    15.12.1976
 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

Multiple rows are displayed on the one panel (limited by the screen size). Each column of the table is formatted according to the data type for that column. For example, numeric data types are displayed as whole or decimal numbers, and date and time fields are displayed as dates or times.

By default, the headings are the names of the columns as defined in the Db2® catalog. You can change them by editing the template.

For SELECT statement View or Edit only, the heading might be displayed as COLnnn where nnn is 001, 002, and so on. This indicates a generated column name. Both of the following examples cause FM/Db2 to generate a column name: 
SELECT 1, dbname FROM SYSIBM.SYSTABLES
SELECT CONCAT(dbname, tsname) FROM SYSIBM.SYSTABLES
One or more columns in the FM/Db2 editor session might be protected. This can occur if:
  • The object being edited has a primary key, and the Allow updates to primary key option is not selected.
  • The object being edited is a read-only view.
  • The object being edited is the result table from an arbitrary SELECT statement (that is, select statement edit).
  • The object being edited is a table, but contains columns, excluding ROWID columns, marked as not updateable in the Db2® catalog. The Db2® catalog tables fall into this category.

If you display data in TABL display format, you can scroll up, down, left, and right.

To display the data in hexadecimal format, use the HEX primary command: 
HEX ON

In TABL display format, the view or edit display always shows the column names for each displayed column (or the alternative field heading if you have defined one).

Optionally, you can display up to 3 additional information lines between the column heading line and the top of data. These are (in order):
  • A line containing the column number (as defined in the Db2® catalog).
  • A line containing the data type for the column (and the length for non-numeric fields).
  • A line showing a ruler above each column. The ruler can include offset information and, optionally, information about primary and foreign keys, and unique indexes.
You can select which, if any, of these additional information lines are displayed on the editor display either:
  • For all FM/Db2 editor sessions by setting the appropriate global option using the Editor Options panel, or
  • For the current FM/Db2 editor session only:
    • For View, you set the appropriate option using the View (option 1) panel.
    • For Edit, you set the appropriate option using the Edit (option 2) panel.

Related tasks

Related references