BTEQ - QUIET in Teradata

When we use multiple sessions in our BTEQ, then QUIET option will be useful.
It is useful for reporting with the statistics of start and end times for the particular running cycle.
Oftenly, QUIET command will be used with REPEAT or = command for better reporting purpose.


QUIET will suppress the outcome of SELECT statements, Activity messages.
Usage example:
.LOGON localtd/dbc, tdpass;
.EXPORT FILE = C:\tx\abc.txt;
SELECT * FROM forgetcode.tbl_employee;

In the above example, the output of select statement will not be printed in the display because of QUIET. However, the output will be exported to the file.