sqlloader and management of blank or empty fields

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sangi1981
Participant
Posts: 99
Joined: Fri Jun 13, 2008 8:10 am

sqlloader and management of blank or empty fields

Post by sangi1981 »

Hi all,
I hope to find some solution to my question....

I load data into Oracle table using sqlloader; my source is a sybase table.
Some fields are empty strings or contain one blank and are not null, yet in target table these fields are not null.
When I use sqlloader, empty string and blank value become null, so loader goes abort, telling me that I try to load null values into not null fields.

Is there some setting to avoid this behavior?
Thanks in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

$APT_ORACLE_PRESERVE_BLANKS = True
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply