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:
Table 2 summarizes ITEQ edit control commands. Chapter 3 contains a complete description of each ITEQ edit control command.
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.