Convert NULL to Blank TPT Fast Load

Tools
Enthusiast

Convert NULL to Blank TPT Fast Load

Insert into emp values 
(:FNAME ,.......

Above Sample Code from TPT works fine. I want to convert null values in flatfile to blank while loading

insert into emp values ( COALESCE(:Fname,' '),....     -- Throws ERROR

insert into emp Values ( case when :Fname is null then ' ' else :Fname End,... --Throws ERROR\

Can Any one Help Me how to convert ?

Thanks.

Tags (2)
3 REPLIES
Enthusiast

Re: Convert NULL to Blank TPT Fast Load

What is the error?

Teradata Employee

Re: Convert NULL to Blank TPT Fast Load

The FastLoad protocol (used by FastLoad and the TPT Load operator) does not support that syntax in the INSERT statement.

Try the TPT Update operator for that type of operation.

-- SteveF
Enthusiast

Re: Convert NULL to Blank TPT Fast Load

Thank You feinholz and Glass for response . http://stackoverflow.com/questions/20554841/convert-null-to-blank-tpt-fast-load/     dnoeth had helped me.