Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2451
lifecycle
previous
Product Category
Teradata Tools and Utilities

Usage Notes

The ITEQ format specification command defaults are listed in Table 8.

 

Table 8: Format Command Defaults 

Format Command

Default

SET FORMAT

Unformat mode

SET NULL AS

blank

SET PAGELENGTH

55 lines

SET RTITLE

60 characters of first statement line

SET SUPPRESS

 

OFF

OFF ALL

SET WIDTH

132 characters

If the SET DEFAULTS command is used in a macro, the command is placed in an ECHO statement that may occur anywhere in the macro. Thus, it is possible to reset the formatting mode and to set defaults at any point in the macro.

The SET DEFAULTS command can be executed within a macro.