Suppressing Repeating Values - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2452
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.