Inserting a Line of Underline Characters - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the BTEQ UNDERLINE command to insert a row of underline characters across a report whenever the value of a specified column changes. (Use the UNDERLINE command either in addition to, or instead of, any of the other BTEQ vertical formatting commands: SUPPRESS, SKIPLINE, or SKIPDOUBLE.)

Example – UNDERLINE

Replace the SKIPLINE command with an UNDERLINE command in the previous example:

.SET UNDERLINE ON 1
.SET SUPPRESS ON 1
select deptno, name from employee
where deptno in (100, 300) 
order by deptno;

The example above produces the following report:

DeptNo  Name
------  -----------
   100  Chin M
        Greene W
        Moffit H
        Peterson J
___________________
   300  Russell S
        Phan A
        Leidner P