TPT: Target Database different than Working Database with LOAD operator

Tools & Utilities
Enthusiast

TPT: Target Database different than Working Database with LOAD operator

How can I use a different target database (not TdpId) than what I declare in WorkingDatabase?  I want the log and error tables to go to a work database, but the target table is in a different database.

For example:

Work.ExampleTable_ET = error table in Work database

Person.ExampleTable = target table in Person database

When I try to set TargetTable='Person.ExampleTable' I get an error.

DEFINE JOB LOAD_JOB
DESCRIPTION 'Loading Data From Results Flat File to Work Table in Teradata'
(
STEP Clear_Table(
APPLY ('DELETE FROM Person.ExampleTable;')
TO OPERATOR ($DDL);
);

STEP Load_Table (
APPLY $INSERT TO OPERATOR ($LOAD() [@LoadInstances])
SELECT * FROM OPERATOR ($FILE_READER() [@FileInstances]);
);
);
Tags (1)
2 REPLIES
Enthusiast

Re: TPT: Target Database different than Working Database with LOAD operator

I was also hoping to get this answered.  I hope it is possible. To the person posting, did anyone ever respond?

Thanks

Teradata Employee

Re: TPT: Target Database different than Working Database with LOAD operator

Provide a fully qualified tablename (including the database name) for the TargetTable attribute (and/or corresponding job variable).

-- SteveF