Modify fastload script

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.

Modify fastload script

Rate Topic

Display Mode

Topic Options

Author

Message

amitaryans

Posted 5/6/2008 1:05:18 AM

Forum Newbie

Group: Forum Members
Last Login: 5/19/2008 7:16:02 AM
Posts: 2, Visits: 19

I want to load data from a flat file into empty table. If the field in the file is NULL, the NULLIF will help me to give default value in the table.
However when the field in the file is having spaces or its zero lenght string, How can i handle this to assign Default values.
Are there anyways to perform some validations on such incoming fields in FASTLOAD SCRIPT.

Thanks,
Amit

Post #11369

Posted 5/6/2008 3:44:56 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 1:24:11 PM
Posts: 76, Visits: 144

hi Amit,

you can try with INMOD routine in your DEFINE command to validate,modify or preprocess data before passing it on to Teradata RDBMS.

thx

-SN

Post #11375

« 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 7:57pm