15.00 - Teradata SQL Statements - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

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 namevalue 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.