how to retrive the data from CLOB Column through datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 am
how to retrive the data from CLOB Column through datastage
i have two clob columns in Oracle DB i have to select the data in datastage i am getting error can anyone suggest me how to retrive the data from CLOB Column through datastage
Srini
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please delete your duplicate post before anyone responds to it.
CLOB is not a supported data type but you can usually successfully use a sufficiently large VarChar field.
CLOB is not a supported data type but you can usually successfully use a sufficiently large VarChar field.
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.
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 am
-
- Participant
- Posts: 15
- Joined: Tue Dec 13, 2005 12:38 am
Re: how to retrive the data from CLOB Column through datast
As told by Ray, If you are using 7.X version of DStage, then using a Long Varchar, can enable to read you using the 'view data' option and will also enable you to process CLOB columns. I have a similar case and I use LongVarchar(4000) for the same.
For 8.0.1 , IBM has provided a patch to fix this, since LongVarchar option to access CLOB din't work there in my case, I think the same fix is applied to the latest versions after 8.0.1
For 8.0.1 , IBM has provided a patch to fix this, since LongVarchar option to access CLOB din't work there in my case, I think the same fix is applied to the latest versions after 8.0.1
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 am
THNAKS EVERYBODY WHO RESPONDED TO MY TOPIC
my problem was solved i am able to read the data using to_char(clob column name)
thnaks all
thnaks all
Srini
-
- Participant
- Posts: 41
- Joined: Wed Oct 08, 2008 9:19 am