Program Function Keys - Interactive Teradata Query Facility

Interactive Teradata Query Reference

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

Program Function Keys

Program Function keys (referred to as PF keys) can be used to invoke frequently used ITEQ commands. When the input area is used for editing input strings, the user must use PF keys to execute ITEQ edit and display control commands.

The SET PFn command may be used to assign a specified ITEQ command to a PF key. For example, executing the command:

SET PF1 ’JOIN;’;

assigns the JOIN command to the PF1 key. When the user presses PF1, the JOIN command is executed.

The user may use the SET PFn command to assign ITEQ commands to PF keys by:

  • Executing a SET PFn command anytime during an ITEQ session.
  • Executing a macro that contains SET PFn commands during an ITEQ session.
  • Defining a startup string that automatically sets PF key assignments at logon.
  • (Refer to SQL Data Definition Language for information on the Teradata SQL CREATE USER and Teradata SQL MODIFY USER statements.) If PF key assignments are not explicitly made by the user, ITEQ sets default assignments during logon. The default PF key assignments are listed in Table 7.

     

    Table 7: Default PF Key Assignments 

    PF Key

    Command

    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

    During an ITEQ session, the user may check the current PF key assignments by entering the SHOW CONTROL command. This command displays the current values of all PF key assignments and ITEQ format controls.