HOLD primary command
In the FM/Db2 editor, the HOLD command sets a scrolling lock on one or more columns.
You can hold columns so that, if you scroll left or right in TABL display format, those columns are always displayed on the left of the panel (regardless of how far you scroll).
You can remove scrolling locks with the FREE editor primary command or by using the H 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
HOLD RESET- Removes all scrolling locks.
HOLD #4- Sets a scrolling lock on column #4.
HOLD #9 #2- Sets a scrolling lock on columns #9 and #2.Note: The columns are held in the order that is specified, so the display shows (from left to right) columns #9 and #2 followed by the non-held columns.
HOLD #5-#9- Sets a scrolling lock on columns #5, #6, #7, #8, and #9.
Availability
- Db2 Browse panel
- Db2 Edit panel
- Db2 View panel
- Any panels displayed with the Object List utility (3.4)