ORABULK problem

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

ORABULK problem

Post by admin »

Hi,

We have just started using the ORABULK control in our
DataStage(4.1) jobs. The control file (.ctl) generated
by this control always has a double quotes (") around
the column names. Because of this, we get an error
"Invalid column name.." while loading data. Once I
remove the double quotes around the column name, the
data load is successful. Is it possible to generate
the .ctl file without the double quotes around the
column name?

Regards
Shrikanth



__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
Locked