BTEQ - Inserting blank lines in Teradata

SKIPLINE will add blankline on your columns.

Syntax:
.SET SKIPLINE ON column_no;

Example:

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

.LOGON localtd/dbc,dbc

.SET SKIPLINE ON 1;

SELECT * from tbl_employee;

.LOGOFF
.EXIT


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

.SET SKIPLINE ON 2;


Then the output will be,
idname
100Rafael
--
100Greene
--
100Moore
--
100Peterson
--
300Russell
--
300Morkel