Teradata SQL Statements - FastLoad

Teradata SQL Statements

Teradata SQL statements define and manipulate the data stored in the Teradata Database. Table 6 summarizes the Teradata SQL statements supported by Teradata FastLoad

Teradata FastLoad supports only the Teradata SQL statements listed in Table 6. 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).

Table 6: 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 Note: 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 and/or middle tier application so they can be customized to each application’s unique needs at the session level. Note: Although Teradata 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 SQL Data Definition Language (B035‑1144) and 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 Teradata Database. For a complete description of the Teradata FastLoad version of the INSERT statement, see “INSERT” on page 125.