After reading up on all the posts, related to this issue, I'm posting this new thread.
I've a job with Oracle DB table as source and target. The source table has a CLOB field with a maximum of 7600 chars. We want the job to typecast CLOB to Varchar, split them and populate it in two separate Varchar fields of 4000 length each.
In the source DRS stage I've all the source fields plus two Varchar(4000) fields (say TGTfield1 & TGTfield2) with derivation as below:
Code: Select all
NVL(CAST(dbms_lob.substr(CLOBfield, 4000,1) AS VARCHAR(4000)),'-')
NVL(CAST(dbms_lob.substr(CLOBfield, 4000, 4001) AS VARCHAR(4000)),'-')
Code: Select all
Source_Load.TGTfield1[1:1999]
Source_Load.TGTfield2[1:1999]
Is this a DataStage issue (NLS?) or Oracle DBMS_LOB package issue?
Kindly advise. Thanks.
-Mav