15.00 - Setting Format Specifications - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
User Guide
featnum
B035-2452-034K

Setting Format Specifications

If you want to print the result as a report, you will probably want to set your own format specifications rather than use the defaults. You set format specifications by executing the ITEQ format commands listed in Table 9. (Any abbreviation allowed in keying a command is indicated in parentheses following the command syntax.)

Format commands may be executed in Format or Unformat mode. Once set, a format specification remains in effect during a session unless changed by a subsequent format command, or by the SET DEFAULTS command. Note that in all format commands, the word “SET” is optional and may be omitted.

 

Table 9: ITEQ Format Commands 

Command

Function

REMARK’charstring’;

Used with Teradata SQL ECHO statement; displays a descriptive comment during execution of a macro.

[SET] DEFAULTS;

Resets all format controls to their default values.

[SET] FORMAT [ON];
(SFO;)

Sets Format mode.

[SET] FORMAT OFF;
(SFF;)

Sets Unformat mode.

[SET] NULL AS ’string’;
(SNA;)

Defines a string to be used for a null field.
Default is blank.

[SET] PAGELENGTH n;

Defines the maximum number of lines (n) for a printed page.

[SET] RTITLE ’string’;

Defines the title (’string’) to appear in the heading of each page of a display or printed report.

[SET] SUPPRESS OFF [ALL/n/,n...];

Resets the suppress feature to allow repeating values in all columns, a specified column (n), or a number of columns (,n...).

[SET] SUPPRESS [ON] [ALL/n/,n...];

Sets the suppress feature to replace any repeating value with blanks following its initial occurrence in all columns, a specified column (n), or a number of columns (,n...).

[SET] WIDTH n;

Defines the number of characters (n) for a printed line. The maximum allowed is 254 characters.