BTEQ - SUPPRESS - Deleting Duplicated Data in Teradata

The BTEQ SUPPRESS command deletes duplicated data by replacing all consecutively repeating values with blank characters in your output reports.

Syntax:
.SET SUPPRESS ON column_no


Example:

Suppose, tbl_employee contains following data
IdName
100Rafael
100Greene
100Moore
100Peterson
300Russell
300Morkel


.LOGON localtd/dbc,dbc

.SET SUPPRESS ON 1;

SELECT * from tbl_employee;

.LOGOFF
.EXIT


Output:
idname
100Rafael
-Greene
-Moore
-Peterson
300Russell
-Morkel