All Forums Tools
icemanc 7 posts Joined 11/12
12 Dec 2013
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 ?

Glass 225 posts Joined 04/10
16 Dec 2013

What is the error?

feinholz 1234 posts Joined 05/08
16 Dec 2013

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.


icemanc 7 posts Joined 11/12
16 Dec 2013

Thank You feinholz and Glass for response .     dnoeth had helped me.

You must sign in to leave a comment.