Specifying a New Freeze and Column Colors

In order to perform the desired edits, you must first redefine the line range so that the new freeze and column coloring operations apply only to the title line, line 1, of each report page:

1. Change the LINES to value from L01 to 001, so that the line range is now defined as 001 –001. This ensures that the change is applied only to the first line.
2. Use the NEWLINES key or arrow keys to position the cursor under the C in the word COLOR. This is the first action needed in order to color the words EMPLOYEES and MARKETING in green (for details of valid color codes, see Appendix B of this guide).
3. Using the SPACEBAR (not the RIGHT key) to move the cursor, type Gs in columns 14 through 30 and columns 64 through 72 in the Color line.
4. Redefine the freeze to extend the length of the report line by typing Fs for the length of the Freeze line.

   The screen appears as follows:

   Figure 35 New Freezing of Edit Report Lines and Columns Screen

   -------------------  CONTROL-D - EDIT REPORT COLUMNS  ----------------(U.E.1.C)

   COMMAND ===>                                                    LINES 001 - 001

   USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    RULER DEFAULT  TYPE VIEW

   THE ORIGINAL LINE

   ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

   1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DEPA

   Use the following 5 lines to Cut & Paste, Color and Freeze columns

   CUT   :

   PASTE :

   COLOR :     

                 GGGGGGGGGGGGGGGGG                                 GGGGGGGGG

   HILITE:

   FREEZE:

   FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

   THE RESULTING LINE

   ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

   1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DEPA

   TO SHIFT, PLACE CRSR ON THE DESIRED LINE AND USE PF10-LEFT, PF11-RIGHT 16.47.13

5. Press the QUICKVIEW key (PF04/PF16) to check the results of these edits.

   The Report Viewing screen is displayed. The words EMPLOYEES and MARKETING are colored green in the report title line.

6. Press the RIGHT key (PF11/PF23).

   The entire report title and the EMPLOYEE NUMBER and EMPLOYEE NAME fields are frozen in place.

   Figure 36 New Frozen Fields in Edit Report LInes and Columns Screen

   ------------- CONTROL-D/V REPORT VIEWING   NOTES    0   PAGE      1 OF        3

   COMMAND ===>                                                   SCROLL ===> CRSR

   USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    04544 DT 050500 RUL DEFAULT

   ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8

   1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DEPA

   EMPLOYEE     EMPLOYEE     UNION   INSURANCE  SICK  VAC

       NO.         NAME       DUES               DAYS  DAYS

   --------  --------------  ------  ---------  ----  ----

     66002    A. HABER        116.00     212.00   01    02

     66019    K. HARARI       150.00     068.00   01    07

     66043    K. TURRO        100.00     112.00   01    10

     66045    W. MAY          156.00     114.00   01    06

     66047    A. FELSEN       154.00     222.00   01    07

     66050    T. HUBERTY      157.00     222.00   01    07

     66052    K. WOOD         158.00     292.00   01    07

     66056    H. RUNDLE       153.00     219.00   01    07

     66059    L. WEST         107.00     222.00   05    05

     66078    N. LAMBERT      075.00     200.00   01    00

     66093    J. SHARPTON     106.00     222.00   01    03

     66112    K. BENNETT      123.00     120.00   01    07

     66113    T. OGURA        122.00     220.00   01    07

     66114    S. MCCLURE      120.00     220.00   01    07

     66115    N. TRACEY       120.00     120.00   01    07

   CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n        11.41.08

   You have now defined two freeze operations – one for line 1 and one for the rest of the lines on each page.

   Return to the editing screens.

7. Press the QUICKVIEW key (PF04/PF16).

   The Edit Report Columns screen is displayed.

   By redefining the freeze for Line 1, the earlier freeze definition (that is not currently displayed) now applies to all lines except line 1, or in other words, to lines 002 – L01.

8. Press the END key (PF03/PF15).

   The Edit Report Lines and Columns screen is displayed.

   If you now select as the model line any line except the first (report title), the Edit Columns screen will display the earlier freeze definition in the line range 002 – L01. However, instead of selecting a new model line, exit the ruler, as described in the next exercise.