Hi Experts,
As per my knowledge Oracle CLOB datatype is equals to LongNvarchar in Datastage.
when i am trying map CLOB data type field from oracle to LongNvarchar in filed in Datastage i am getting unsupported data type error.
I could not able to import metadata from oracle table because of CLOB datatype.
Is there any Environmental Variables need to be set to over come this issues?
Could you please share your valuable suggestions on this?
Thanks
kumar
Reading/writing Oracle CLOB Datatype
Moderators: chulett, rschirm, roy
Re: Reading/writing Oracle CLOB Datatype
Are you using the Oracle connector?
In the Connector Stage a CLOB equates to a Long Varchar
In the Connector Stage a CLOB equates to a Long Varchar
Modern Life is Rubbish - Blur
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines
Re: Reading/writing Oracle CLOB Datatype
RAW(n) datatype not supported in datastage oracle connector, So CLOB datatype may also not supported. If oracle record length exceeds 32KB then job aborts...Pls advice if wrong.
Last edited by tbharathkumar on Wed Apr 20, 2011 5:06 am, edited 1 time in total.
Re: Reading/writing Oracle CLOB Datatype
I've never used RAW, however from the 8.5 manual
Oracle LOB and XMLType data types
The Oracle connector supports reading and writing Oracle LOB data types BFILE,BLOB, CLOB, NCLOB, LONG RAW, RAW, and XMLType.
Oracle LOB and XMLType data types
The Oracle connector supports reading and writing Oracle LOB data types BFILE,BLOB, CLOB, NCLOB, LONG RAW, RAW, and XMLType.
Modern Life is Rubbish - Blur
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines
Re: Reading/writing Oracle CLOB Datatype
We are in datastage version 8.1, i guess your answer is correct for Datastage ver 8.5
Regards,
Bharath Tipirisetty
Bharath Tipirisetty
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is not how DSXchange works. Any people who feel they can contribute something are welcome to do so. And anyone who feels that he or she can not contribute anything useful are at liberty to remains silent; there is no compulsion on anyone.smart2786 wrote:Hi ray,
Could you please help on this??
Thanks
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Reading/writing Oracle CLOB Datatype
Did you clarify that you were using the Connector, not the Enterprise / Other Stage?blewip wrote:Are you using the Oracle connector?
Modern Life is Rubbish - Blur