ITEQ System Control Commands - 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

ITEQ System Control Commands

System Control commands are used to control an ITEQ session. When the user enters a System Control command, ITEQ displays a message that indicates success or failure of the command. Table 5 lists the system control commands. Chapter 3 contains a complete description of each ITEQ system control command.

 

Table 5:  ITEQ System Control Commands

Command

Function

ABORT

Terminates a Teradata SQL statement that is in process.

CANCEL

Discards the result of the preceding SELECT statement or macro execution. Preceding results are normally discarded when a new data-generating statement or macro is entered.

FILE

Creates a client file containing the result of the current data-generating statement.

LOGOFF

Terminates an ITEQ session on the Teradata DBS.

LOGON

Establishes an ITEQ session on the Teradata Database system.

PRINT

Sends the result of the current SELECT statement or macro to the printer. For each print command executed, one copy of a result is printed.

QUIT

Terminates the Teradata Database system session and exits ITEQ.