15.00 - Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

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

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.