SHOW primary command
In the FM/Db2 editor, the SHOW command adds a hidden column to the data display. You can hide a column from display by using the HIDE editor primary command or by using the S prefix command in the template editor.
Syntax
- fieldref
- A single field reference (for example,
#1), a range (for example,#2-#5), or a list of single field references/ranges separated by spaces (for example,#1 #4 #6-#7). A single field specification is#n; n is a positive integer and cannot exceed the number of columns in the Db2® object or result table being processed. - fldname
- The name of a column in the Db2® object or result table being processed. The column name can be preceded by a pound sign (#). Any value entered is translated to upper case if the "Translate Db2® object names" system's option is selected.
Examples
SHOW ALL- Shows all columns.
SHOW RESET- Shows all columns.
SHOW #4- Shows the data for column #4.
SHOW #7 #1- Shows the data for columns #1 and #7.
SHOW #2-#5- Shows the data for columns #2, #3, #4, and #5.
Availability
- Db2 Browse panel
- Db2 Edit panel
- Db2 View panel
- Any panels displayed with the Object List utility (3.4)