Use CASE statement in 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.

Use CASE statement in Fastload script

Rate Topic

Display Mode

Topic Options

Author

Message

amitaryans

Posted 5/2/2008 2:11:06 AM

Forum Newbie

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

Hi All,

Can we use CASE statement in a fastload script. I want to check for zero length string. Is it possible to use some thing like this

CASE(LENGTH(:input_string)=0) Then 'UNKNOWN' Else :input_string

Please advise.

Thanks,
Amit

Post #11344

Jian

Posted 5/3/2008 11:35:06 PM

Forum Newbie

Group: Forum Members
Last Login: 5/4/2008 3:57:27 AM
Posts: 5, Visits: 43

You can't use case statement directly in the fastload script.
It is possbile for you to embed INMOD into fastload to do such transfer job.

Or you can use NULLIF in the define section.
But with this method, the input field containing the specified value should be treated as NULL...

Post #11354

« 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 6:50pm