how change OPTIONALLY ENCLOSED in load option

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
NSIT-DVP-01
Premium Member
Premium Member
Posts: 46
Joined: Wed May 16, 2007 1:54 am
Location: Paris
Contact:

how change OPTIONALLY ENCLOSED in load option

Post by NSIT-DVP-01 »

I am loading data from a SQL Server database into Oracle through a parallel job.
I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with following settings:
Write Method: Load
Write Mode: append

My issue comes with the fact that in my data I have double quotes ("), single quotes ('), and commas (,). I have found where to change the delimiter in the APT_ORACLE_LOAD_DELIMITED variable to take care of the comma issue. However, it insist on using double quotes as string qualifier and adding OPTIONALLY ENCLOSED BY X'22' to the control file. This is causing lots of the data to error when it should not. where can i change the value of "OPTIONALLY ENCLOSED".
Post Reply