DSXchange

Can someone please shed some light on the resolution of the following problem:

I'm using in the Oracle Stage ( PX 6.x DataStage) the options:
Write Method= Load
Write mode= Append.

But i can't load the field CLOB ( Special Oracle data type) , extract like a varchar !
From Director i'm getting error as above:

"Column XXXX has unsupported type. "

NB. If i manually process the same .dat like a sqlloader work's well.

bye, DR.

the only solution about this problem is :

using Upsert mode Loading in Oracle Table
and perform function to_clob()

Bye, D.R.

Hi,

I looked into the ORAOCI Bulk Load and Oracle Express Load. Under Load Mode or Load Action, I did not see "Upsert" selection there. Can you set this up in DataStage? Thanks.

dr_personale wrote:the only solution about this problem is :

using Upsert mode Loading in Oracle Table
and perform function to_clob()

Bye, D.R.