15.00 - ITEQ Format Specification Commands - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

ITEQ Format Specification Commands

ITEQ format specification commands, listed in Table 4 are used to set format controls for a displayed or printed report. Chapter 3 contains a complete description of each ITEQ format specification command.

 

Table 4: ITEQ Format Specification Commands 

Command

Function

REMARK

Used in a macro to supply commentary.

SET DEFAULTS

Resets the format specifications to the default values of the ITEQ formatting commands.

SET FORMAT

Sets the formatting mode for displaying and printing the selected results.

SET NULL AS

Specifies a character to be used in a null field.

SET PAGELENGTH

Defines the maximum number of lines in a printed page of a result.

SET PROGRAM FUNCTION KEY

Assigns an ITEQ command to a specified program function key.

SET RTITLE

Specifies a title that appears in the heading of each page of a displayed or printed report.

SET SUPPRESS

Specifies whether consecutive repeating values from a selected result are to be printed as displayed.

SET WIDTH

Sets the maximum line width for a printed page.

The user can print the data generated by a statement at any time before the data is discarded with the PRINT command. The Teradata DBS formats result pages created in Format mode according to the most recently defined format specifications. The system prints data pages created in Unformat mode as they were displayed on the terminal screen, adjusted to page length and line width specifications.

A user can also file the data generated by a statement using the FILE command, which creates a client flat file. The flat file format contains no headings, spacing, or summary (subtotals or totals) results for selected column data.