Re: SQL*LOADER - NOT NULL

analyst_user_at_my-deja.com wrote:
>
> I have a .dat file that has spaces for some columns.
> Some of these columns are defined as NOT NULL.
> When I run the script I get the error of the NOT NULL columns.
>
> If there are spaces in the .dat file for a column, SQL*LOADER
> translates it to being NULL? Why doesn't SQL*LOADER load the spaces
> into the fields?
>
> Something I tried is "decode(:LNAME,NULL,' ',:LNAME)", but I don't want
> to do this if it is unnecessary.
>
> I would appreciate any help.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

I don't have the manual right in front of me at the moment, but there is a loader command that instructs the load to preserve spaces. This is probably what you want to do.

Donna Received on Sat Jun 12 1999 - 18:18:23 CEST