How to Specify Page Breaks | Basic Teradata Query - Specifying Page Breaks - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

Example – PAGEBREAK

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