HIDE primary command
In the FM/Db2 editor, the HIDE command removes a column from the data display. A hidden column can be displayed by using the SHOW 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
HIDE RESET- Shows all hidden columns.
HIDE #4- Does not display column #4.
HIDE #7 #1- Does not display columns #1 and #7
HIDE #2-#5- Does not display 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)