Inserting a Line of Underline Characters
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
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