Viewing the Effect of Format Commands - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Product
Interactive Teradata Query Facility
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2452
Product Category
Teradata Tools and Utilities

Viewing the Effect of Format Commands

You normally apply ITEQ format commands only to a result displayed in Format mode. However, you may apply the following format commands to a result displayed in Unformat mode:

  • SET NULL AS
  • SET PAGELENGTH
  • SET SUPPRESS OFF
  • SET SUPPRESS ON
  • SET WIDTH
  • When a format command is successfully executed, an appropriate message is displayed in the display area; if a command is unsuccessful, an error message is displayed. If an successful command is executed from the input area, the command is erased upon execution. An unsuccessful command remains displayed and the cursor moves to the beginning of the input area.

    If you are viewing a result while executing format commands to tailor it, the effect of these commands does not automatically appear in the result as viewed. In order to view the effect of format commands, execute:

    BACKWARD *;

    The screen goes blank, then the processing message is displayed as part of the first page of the result in Unformat mode.

    In Format mode, the processing message for the result is displayed on a page by itself. To display the first page of the newly formatted result, execute:

    FORWARD;