DATABASE
Purpose
Teradata TPump supports the Teradata SQL DATABASE statement, which changes the default database qualification for all unqualified DML and DDL statements.
Syntax
where
Syntax Element |
Description |
|||
database |
New qualified default database for the error table Changes the database from the one originally specified by the BEGIN LOAD command. |
Usage Notes
The DATABASE command only affects native SQL commands. In particular, it has no effect on the BEGIN LOAD command.
The DATABASE command does affect INSERT, UPDATE, DELETE, and EXEC statements issued as part of a load. (When Teradata TPump logs on sessions, it immediately issues a DATABASE statement on each session.)
The DATABASE command does not affect the placement of Teradata TPump macros.