The FREEZE and THAW Commands

Describes the FREEZE and THAW commands.
The FREEZE command lets you designate a list of one or more columns which are not subject to left/right scrolling. Frozen columns remain anchored in place regardless of the scroll command. For example you can FREEZE a primary or foreign key column so that it is always visible for reference.
NOTES on FREEZE:
1. It is not necessary to explicitly lock the SELECT field.
2.
RLX
locks indicator variables along with their corresponding host main variables.
3.
RLX
limits the sum of the widths of the frozen columns to the panel's logical screen width.
The following panel illustrates the display before the following FREEZE command is executed:
Command ===> FREEZE (INTEGER CHAR5 7)
SQL Query Result 'DATATYPE' --------------------------------------- ROW 1 OF 14 Command ===> Scroll ===> HALF INTEGER SMALLINT DEC55 CHAR5 MDV005 DATE TIME 1(I) 2(S) 3(P) 4(C) 5(V) 6(DATE) 7(TIME) 57 57 0.57000 C57 VC57 2003-01-21 16.42 58 58 0.58000 C58 VC58 2003-01-21 16.42.23 59 59 0.59000 C59 VC59 2003-01-21 16.42.23 63 63 0.63000 C63 VC63 2003-01-21 16.42.23 78 78 0.78000 C78 VC78 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 87 87 0.87000 C87 VC87 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-10-18 11.16.45 100 100 0.10000 C100 VC100 2003-10-18 11.16.45 100 100 0.10000 C100 - 2003-10-18 11.16.45
After FREEZE executes, the query result columns named INTEGER, CHAR5, and TIME (7th column in the query result column series) begin the sequence. These columns appear on every display and are not subject to horizontal scrolling. The next panel illustrates the display after the FREEZE command is executed.
The THAW command lets you unlock one or more frozen columns so that they are once again subject to LEFT and RIGHT scrolling.
SQL Query Result 'DATATYPE' --------------------------------------- ROW 1 OF 14 Command ===> Scroll ===> HALF INTEGER CHAR5 TIME SMALLINT DEC55 MDV005 DATE 1(I) 4(C) 7(TIME) 2(S) 3(P) 5(V) 6(DATE) 57 C57 16.42.23 57 0.57000 VC57 2003-01-21 58 C58 16.42.23 58 0.58000 VC58 2003-01-21 59 C59 16.42.23 59 0.59000 VC59 2003-01-21 63 C63 16.42.23 63 0.63000 VC63 2003-01-21 78 C78 16.42.23 78 0.78000 VC78 2003-01-21 82 C82 16.42.23 82 0.82000 VC82 2003-01-21 82 C82 13.24.23 82 0.82000 VC82 2003-11-23 82 C82 16.42.23 82 0.82000 VC82 2003-01-21 82 C82 13.24.23 82 0.82000 VC82 2003-11-23 87 C87 16.42.23 87 0.87000 VC87 2003-01-21 93 C93 16.42.23 93 0.93000 VC93 2003-01-21 93 C93 11.16.45 93 0.93000 VC93 2003-10-18 100 C100 11.16.45 100 0.10000 VC100 2003-10-18 100 C100 11.16.45 100 0.10000 - 2003-10-18