By default, BTEQ uses all of the space available on each page for report information. Use the BTEQ PAGEBREAK command to force a page break and begin with a new page whenever the value of a specified column changes.
Replace the UNDERLINE command with a PAGEBREAK command in the previous example:
.SET PAGEBREAK 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 two-page report:
page 1:
DeptNo Name
------ -----------
100 Chin M
Greene W
Moffit H
Peterson J
page 2:
DeptNo Name
------ -----------
300 Russell S
Phan A
Leidner P