Viewing the Effect of Format Commands - Interactive Teradata Query Facility

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;