Suppressing Repeating Values
To suppress the repeating column values in column 1 (the DeptNo column), execute the command:
SET SUPPRESS ON 1;
To suppress repeating values in every column of a result, execute the command:
SET SUPPRESS; or SET SUPPRESS ALL;
After executing these format commands and executing the BACKWARD/FORWARD command sequence described earlier, the result now looks like this (Figure 11):
Figure 11: Alternate Page ResultNote that a blank line is inserted before a value change in a column that is under suppress control.