Using PF Keys to Execute Command - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2452
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using PF Keys to Execute Command

To use ITEQ edit commands to edit a statement in the input area, you use program function (PF) keys that have been assigned to these commands. A command is then executed by pressing the appropriate PF key.

When you log onto ITEQ, certain PF keys are automatically assigned to ITEQ commands. This automatic assignment is called a “default.”

Default PF key assignments for edit commands are listed in Table 4. The heading “87-key” designates the settings for a 3270-type terminal with an 87-key keyboard. The heading “75‑key” designates settings for the 75‑key 3270 keyboard.

 

Table 4: Default PF Key Assignments, Edit Commands 

87-Key

75-Key

Command

PF13

PF1

SHOW;

PF14

PF2

SUBMIT;

PF15

PF3

ADD;

PF17

PF5

CLEAR INPUT;

PF18

PF6

REMOVE;

PF21

PF9

UP;

PF24

PF12

DOWN;

PF keys 16, 19, 20, 22, and 23 (or PF keys 4, 7, 8, 10, and 11) automatically default to other ITEQ commands, discussed later in this guide. For a complete listing of PF keys assigned to ITEQ commands, refer to Appendix C.

If these default assignments are not convenient for you, you may make your own PF key assignments.

To assign a PF key to an ITEQ command, use the SET PFn ITEQ command. For example, to assign the PF23 key to the UP edit command, enter:

SET PF23 ’UP 1;’;

in the input area and press ENTER.

You may assign PF keys to ITEQ commands anytime during a session. However, because you execute the SET PFn command from the input area, it is more convenient to assign PF keys before you begin entering and editing Teradata SQL statements in the input area. If you are not using the default assignments, before editing statements in the input area you must first assign PF keys to the edit commands ADD, REMOVE, UP, and DOWN, as well as to JOIN and SPLIT, which are not assigned PF keys by default.

Your own PF key assignments may be made automatically when you log on to the Teradata DBS. Log on to the Teradata DBS and enter a Teradata SQL MODIFY USER statement for yourself that specifies the assignments in a STARTUP string that is executed when you log on to the Teradata DBS. The Teradata SQL MODIFY USER statement is described in SQL Data Definition Language.

For example, to assign PF keys to SPLIT and JOIN commands during subsequent logons if your username were Inglis, you would type:

MODIFY USER Inglis AS
STARTUP =’ECHO ’’SET PF1 ’’’’SPLIT;’’’’;’’;
’ECHO ’’SET PF2 ’’’’JOIN;’’’’;’’;’;

In the STARTUP string, each ITEQ edit command is enclosed within a SET PFn command and each PFn command is enclosed within a Teradata SQL ECHO statement. The Teradata SQL ECHO statement (discussed in SQL Data Definition Language) is needed to convey the command to ITEQ.

The entire STARTUP string is enclosed by apostrophes. Each SET PFn command is identified within the string by double apostrophes, each edit command by quadruple apostrophes. Each Teradata SQL ECHO statement and edit command, as well as the Teradata SQL MODIFY USER statement itself, is terminated by a semicolon.

To display current PF key assignments during an ITEQ session, execute the SHOW CONTROL command, as follows:

SHOW CONTROL;

This command also displays the current setting of ITEQ display and format commands.