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 allFM/Db2 editor sessions by setting the appropriate
global option using the Editor Options panel, or
For the currentFM/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.
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.