DATABASE - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.