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.