Specifying Headers and Footers - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
Text for headers and footers can be specified for the top and bottom of each page. They can include the following information:
  • The report date. This is the date that the print file is created, not the date the report is printed.
  • The report time. This is the time that the print file is created, not the time the report is printed.
  • Page number.
  • The current value of the data in a certain column of the report. Usually, this is a column specified by an ORDER BY clause in the SELECT statement.
  • A running text string that identifies the report. This is usually a descriptive version of the SELECT statement.

If a header (or title) for a report is not specified, BTEQ uses a default one-line header or title that includes the report date (left-justified), as much of the SQL request text that fits (centered), and the page number (right-justified).

If a footer is not specified, BTEQ uses the available space at the bottom of the page for additional rows of report data.