How to Specify Printer Formats | Basic Teradata Query - Specifying Printer Formats - 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
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.