Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

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

Usage Notes

Before a report is printed, the user can enter the SHOW CONTROL command to display ITEQ format control values. Table 10 lists the ITEQ format controls and their system default values.

 

Table 10: Default ITEQ Format Control Values 

Format Control

Default Value

Output Format Mode

Unformat

Output Report Title

?

Print Page Length

55

Print Line Width

132

Retrieve Limit

0 (no limit)

Null Character

blank

Column Suppress

OFF for all column(s)

PF1 and PF13

SHOW

PF2 and PF14

SUBMIT

PF3 and PF15

ADD

PF4 and PF16

PRINT

PF5 and PF17

CLEAR INPUT

PF6 and PF18

REMOVE

PF7 and PF19

BACKWARD

PF8 and PF20

FORWARD

PF9 and PF21

UP

PF10 and PF22

LEFT

PF11 and PF23

RIGHT

PF12 and PF24

DOWN

If the display area is not large enough to display the format controls, the user must issue the SHOW CONTROL command repeatedly until the last format control value page is displayed.

The format control commands can be used to change the value of a format control.