FREE primary command

In the FM/Db2 editor, the FREE command removes any scrolling lock on one or more columns. You can set scrolling locks with the HOLD editor primary command or by using the H prefix command in the template editor.

Syntax


1 FREE
1 fieldref
1 fldname
1 ALL
1 RESET
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

FREE ALL
Removes all scrolling locks.
FREE RESET
Removes all scrolling locks.
FREE #4
Removes any scrolling lock from column #4.
FREE #9 #2
Removes any scrolling lock from columns #2 and #9.
FREE #5-#9
Removes any scrolling lock from columns #5, #6, #7, #8, and #9.

Availability

Related tasks