Easy Loader Target Working Database

Tools & Utilities
Enthusiast

Easy Loader Target Working Database

Hello:

I posted a few weeks ago here just for some background.

http://forums.teradata.com/forum/tools/easy-loader-issue 

I'm finding I can't use Easy Loader to load a Target table unless that table is created under my default logon directory and that table is qualified in the command line with my default database.  

If I qualify my target table (-t) with another database name or if I qualify my target table (-t) with another database name and also set the working database to that database (--TargetWorkingDatabase) I get a "2583: Worktable is missing" error...

The only way I've been able to load a table from another Teradata table using Easy Loader is by explicity setting the database qualifier to my default database (-t switch) and having the table created inside of this database.  My load happens to be taking a table from one Teradata system and moving it to another Teradata system (tables are not on the same system).

Thanks for listening again!

Tags (2)