15.00 - Viewing the Effect of Format Commands - 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

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;