Home
Working with FM/Db2
Viewing and changing Db2® data
To view the contents of a Db2® table or view, use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/Db2 Browse Utility (option B).
Viewing data in a File Manager/Db2 editor session
Changing the view of displayed data
Displaying the data type

Displaying the data type

In SNGL display format, use the TYPE primary command to show or hide the data type (and, for non-numeric columns, the length of the column) for each displayed column:

If the data type details are not currently displayed, FM/Db2 displays an additional column (between the name and data columns) showing the data type details for each column.
If you enter the TYPE primary command in TABL display format, the display is unaltered. However, if you change to SNGL display format, the display status of the additional column is reversed.
If the data type details are already displayed, the TYPE primary command removes them from display.

Note: You can also display the data type details by selecting the Show data type option (for TABL, SNGL, or both display formats).

Related references