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