If that doesn't work, you could also try tacking on a ZEROIFNULL command around the column when you import it to the flatfile, then Use NULLIFZERO in your insert statement (This would only work however if the column in the base table didn't have any 0's to begin with).

Re: teardata fastload and null values.....

Hi,There is no way you can pass a string of NULLs to or in a file. The point here is that the NULLs get converted to blank spaces. In your Mulitload script, you can use the CASE statement as follows to convert the spaces back to NULL valuesCASE WHEN :val = ' ' THEN NULL ELSE :val ENDThis will do the appropriate conversion. Use this only if your source field does not have blank spaces as a possibility. You can specify 1, 2, 3 or more blank spaces to exactly recognise a blank space and a NULL conversion field as you deem appropriate.