Teradata SQL Statements | Teradata FastLoad - 17.10 - Teradata SQL Statements - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

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.