BTEQ - Omit in Teradata

It will exclude specified columns returned from SQL SELECT statements.

Syntax:
.SET OMIT ON n;

n- no of columns to be omitted ordered from left to right, and separated by a comma or one space.

Omitting all columns :
.set format on
.set defaults
.set omit off
.set omit on all

Omitting second column from left:
.set defaults
.set format on
.set omit off
.set omit on 2