SHOW primary command
In the ZDT/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)