Problem loading data files having null values.

A year later.

Thanks Ted for your post which led me to the right process on my end.

I fear that this original post went way off track into what a NULL is
and lost sight of the original point - treatment of empty fields
during LOAD. It really does not matter how you feel about how a NULL
should be represented, it matters about how open you can be and accept
what other vendors are providing in load files to represent NULL. In
a pure Windows environment (with no unix tools), I'm stuck with a
problem of converting empty fields to \N. Any loader worth it's salt
should care more about dealing with a basic problem like this as
opposed to an esoteric one like 'record start' (first time I've ever
seen that in a loader).

j.