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