How to Specify the Page Size | Basic Teradata Query - Specifying the Page Size - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

Use the BTEQ WIDTH and PAGELENGTH commands to specify the size of the paper for a report.

Standard 8-1/2 x11 inch and 11x14 inch fan-fold computer paper accommodates the following page size specifications:
  • 8-1/2 x11 inch – Width = 80 characters; length = 66 lines
  • 11x14 inch – Width = 123 characters; length = 66 lines

For special nonstandard printer forms, it is necessary to measure them to determine the appropriate print width and length specifications.

Example – WIDTH and PAGELENGTH

To specify the width of the paper, enter:

.SET WIDTH n

where n is the number of print characters. The default value is 75, which is appropriate for a typical display screen.

To specify the length of the paper, enter:

.SET PAGELENGTH n

where n is the number of lines per page. The default value is 55, which leaves a print gap of 11 lines at the form perforations for several lines for headers and footers.