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.
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.
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.
SELECT 1, dbname FROM SYSIBM.SYSTABLES
SELECT CONCAT(dbname, tsname) FROM SYSIBM.SYSTABLES
- 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.
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).
- 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.
- 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
- Working with templates
- Scrolling
- View and Edit options (options 1 and 2)
- ROWID columns
- Setting options for the current FM/Db2 editor session
- Excluding rows
Related references