How to Specify Printer Formats | Basic Teradata Query - Specifying Printer Formats - 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 following BTEQ commands to specify the printer formats:
  • WIDTH – Specifies the number of characters per line.
  • PAGELENGTH – Specifies the number of lines per page.
  • FORMCHAR – Specifies the form-feed character.

Printer format specifications can be changed any time. However, the FORMAT command option must be set to ON to activate the changes.

By default, the BTEQ FORMAT command option is set to OFF. In this condition, BTEQ does not process printer format specifications, except WIDTH, and automatically centers all reports based on the WIDTH specification.

Set the FORMAT command option to ON to print reports using the printer format specifications.