15.00 - ITEQ Edit Control Commands - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

ITEQ Edit Control Commands

ITEQ edit control commands allow the user to enter, edit, and execute Teradata SQL statements and macros (discussed later in this chapter). Edit facilities allow the user to:

  • Enter input of one or more lines. The number of lines may exceed the display space available on a single screen.
  • Modify lines by:
  • Inserting or deleting characters in a line
  • Inserting or deleting lines
  • Splitting or joining lines
  • Display selected portions of a statement or macro when either is too long to be displayed on one screen.
  • Enter a new command or statement while viewing the processing results of the previous input.
  • Display the most recently processed statement or macro for modification.
  • Invoke ITEQ edit control commands using program function (PF) keys on the terminal keyboard.
  • Table 2 summarizes ITEQ edit control commands. Chapter 3 contains a complete description of each ITEQ edit control command.

     

    Table 2: ITEQ Edit Control Commands 

    Command

    Function

    ADD

    Adds one blank line to the edit area following the current cursor position.

    CLEAR INPUT

    Clears the input area or the display area (when it is used for input).

    DOWN

    Moves the edit area display down (forward) over the current input string when this string exceeds the size of the current display.

    INPUT

    Sets the display area for input.

    JOIN

    Appends the next line of characters to the cursor position on the current line, overlaying the cursor and erasing any characters to the right of the cursor.

    REMOVE

    Removes the line in the edit area on which the cursor is currently positioned.

    SPLIT

    Creates a new line following the current line and moves characters right of (and including) the cursor to the new line.

    SUBMIT

    Submits a statement that was entered in the display area during input mode.

    UP

    Moves the edit area display up (backward) over the current string when this string exceeds the length of the current display.

    With the exception of INPUT and SUBMIT, which apply specifically to the display area, edit control commands may be used either in the input area, or in the display area when it is set for input. The area that is being used for input is designated the “edit area.”

    Insertion or deletion of characters within a line are terminal keyboard edit functions. The INSERT MODE key allows characters to be inserted before the cursor position. The DEL key deletes the character where the cursor is positioned.