BTEQ - Inserting a Line of Underline Characters in Teradata


Syntax:
.SET UNDERLINE ON column_no;

Example:

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

.LOGON localtd/dbc,dbc

.SET UNDERLINE ON 1;

SELECT * from tbl_employee;

.LOGOFF
.EXIT


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

.SET UNDERLINE ON 2;


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