Using Display 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

ITEQ provides display commands that let you view result pages. These commands are listed in Table 7. (Any abbreviation allowed in keying a command is indicated in parentheses following the command syntax.)

 

Table 7: Display Commands 

Command

Function

BACKWARD [n];
(BWD;)

Moves screen backward one page or n number of pages.

FORWARD [n];
(FWD;)

Moves screen forward one page or n number of pages.

LEFT [n];

Shifts screen to the left 52 positions or n number of positions.

RECALL;

Causes the result that was previously displayed to be redisplayed after being erased by execution of an ITEQ command.

RIGHT [n];

Shifts screen to the right 52 positions or n number of positions.

PF keys are automatically assigned to display commands when you log on to ITEQ. PF keys assigned to display commands are listed in Table 8. (The heading “87-key” designates the settings for a 3270- type terminal with an 87-key keyboard; “75-key” designates settings for the 75-key 3270 keyboard.)

 

Table 8: Default PF Assignments, Display Commands 

87-Key

75-Key

Command

PF19

PF7

BACKWARD;

PF20

PF8

FORWARD;

PF22

PF10

LEFT;

PF23

PF11

RIGHT;

You may also specify your own PF key assignments, as described in the Chapter 4. After a PF key is assigned, you may execute an ITEQ display command by pressing the PF key assigned to the command.

As an alternative to using PF keys, you may key a display command and press Enter.

Note: In order to key a display command in the input area while viewing the result of a SELECT statement, you must erase the SELECT statement that produced the result. You then cannot compare the statement against the result. (However, if you want to modify the statement, you can do so without re-entering the statement completely by executing the SHOW command, assigned to the PF13 key. The statement is redisplayed in the display area, where it can be modified and entered using the SUBMIT command.)

In general, successful execution of a display command is indicated by an appropriate movement on the terminal screen. If a command is successfully executed from the input area, it is erased from that area upon execution. If the command fails, the cursor moves to the beginning of the input area and the unsuccessful command, if executed from that area, remains displayed.

You may display the current setting of display commands by executing the SHOW CONTROL command, as follows:

SHOW CONTROL;

This command also displays the current setting of ITEQ format commands and PF key assignments.

The examples below assume that you are using PF keys with their default assignments to execute display commands.