ITEQ Format Specification Commands - Interactive Teradata Query Facility

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.