Teradata TPump Teradata SQL Statements
The following Teradata SQL statements supported by Teradata TPump are included in this chapter because they require special considerations for use with Teradata TPump. They are used for loading purposes and for creating Teradata TPump macros. The syntax and use of these Teradata SQL statements is described in detail in this chapter.
Table 25 lists the Teradata SQL Statements supported by Teradata TPump.
|
Statement |
Definition |
|
Changes the default database qualification for all DML statements. |
|
|
Removes specified rows from a table. |
|
|
Specifies a user‑created (predefined) macro for execution. The macro named in this statement resides in Teradata Database and specifies the type of DML statement (INSERT, UPDATE, or DELETE) being handled by the macro. |
|
|
Adds new rows to a table by directly specifying the row data to be inserted. |
|
|
Changes field values in existing rows of a table. |