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.
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.