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.
Load CLOB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Mon Oct 04, 2004 10:54 am
Load Mode
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.
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.