Insert into emp values
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 ?
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.
Thank You feinholz and Glass for response . http://stackoverflow.com/questions/20554841/convert-null-to-blank-tpt-fast-load/ dnoeth had helped me.