15.00 - Suppressing Repeating Values - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
User Guide
featnum
B035-2452-034K

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 Result

Note that a blank line is inserted before a value change in a column that is under suppress control.