wrk tables

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

wrk tables

Rate Topic

Display Mode

Topic Options

Author

Message

maverick

Posted 5/15/2008 4:23:55 PM

Forum Newbie

Group: Forum Members
Last Login: 7/4/2008 10:57:24 AM
Posts: 5, Visits: 13

Hi

Can anyone explain what is a wrk table and what is its usage? Do we have to create it explicitly or does the loader utility creates it by default for each target table ? Can we use this table to track errors?

Thanks

Post #11456

Posted 5/16/2008 1:41:26 PM

Supreme Being

Group: Forum Members
Last Login: 8/11/2008 3:00:36 PM
Posts: 76, Visits: 147

hi,

work tables are needed by the load utilities to log errors and assist load process. Just the work table name has to be supplied and the utility takes care of of the rest.

thx

-SN

Post #11472

maverick

Posted 5/19/2008 3:00:02 PM

Forum Newbie

Group: Forum Members
Last Login: 7/4/2008 10:57:24 AM
Posts: 5, Visits: 13

Hi

So I have to mention the wrk table names at the time of creation of the utility script ? What happens if I do not mention any table names?
Thanks

Post #11489

Posted 5/21/2008 4:12:56 PM

Supreme Being

Group: Forum Members
Last Login: 8/11/2008 3:00:36 PM
Posts: 76, Visits: 147

hi,

you can specify the work and error tables using below format(eg. MLoad) in your load script :

..........
WORKTABLES Database.WT_
ERRORTABLES Database.ET_
Database.UV_
.............

if you dont specify anything using the keywords WORKTABLES and/or ERRORTABLES, teradata aumatically creates these tables and maintains it.

thx

-SN

Post #11539

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:35pm