Teradata SQL statements define and manipulate the data stored in the Teradata 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 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 and/or middle tier application so they can be customized to each application’s unique needs at the session level. 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.