Teradata SQL Statements | Teradata FastLoad - 17.20 - Teradata SQL Statements - FastLoad

Teradata® FastLoad Reference - 17.20

Release Number
June 2022
English (United States)
Last Update

Teradata SQL statements define and manipulate the data stored in the database. The following table summarizes the Teradata SQL statements supported by Teradata FastLoad.

Teradata FastLoad supports only the Teradata SQL statements listed in the following table. To use other Teradata SQL statements, Teradata FastLoad must first be exited, and the statements entered from another application, such as Basic Teradata Query (BTEQ).

Teradata SQL Statements Supported in Teradata FastLoad 
Teradata SQL Statement Function
CREATE TABLE Defines the columns, index, and other qualities of a table
DATABASE Changes the default database
DELETE Deletes rows from a table
FastLoad also supports temporal syntaxes like CURRENT VALIDTIME, SEQUENCED VALIDTIME, VALIDTIME, NONSEQUENCED VALIDTIME and NONTEMPORAL clauses prefixed in DELETE/DEL statement.
DROP TABLE Removes a table and all of its rows from a database
INSERT Inserts rows into a table
SET QUERY_BAND...FOR SESSION Allows a set of name-value pairs to be defined by the user or middle tier application so they can be customized to each application’s unique needs at the session level.
Although the database accepts the “SET QUERY_BAND ... FOR TRANSACTION;” , Teradata FastLoad rejects it, displays an error message and terminates.

For syntax and a complete description of each Teradata SQL statement, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

The Teradata FastLoad version of the INSERT statement includes a special “wildcard” table name specification that is not supported by the database. For a complete description of the Teradata FastLoad version of the INSERT statement, see INSERT.