Page 1 of 1
how to retrive the data from CLOB Column through datastage
Posted: Tue Feb 17, 2009 3:55 am
by uppalapati2003
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
Posted: Tue Feb 17, 2009 2:39 pm
by ray.wurlod
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.
Posted: Tue Feb 17, 2009 10:23 pm
by uppalapati2003
i am using datatype as longvarchar in oracle enterprise stage in datastage but i am getting below error
Internal Error: (colDesc):orautils.C: 1714: getColDesc failed.
i am successfully loading the data but i am not able to retrive the data.
Posted: Wed Feb 18, 2009 8:29 am
by chulett
Search the forums for "CLOB", it has been discussed here quite a bit.
Re: how to retrive the data from CLOB Column through datast
Posted: Wed Feb 18, 2009 2:10 pm
by Vikas Jain
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
THNAKS EVERYBODY WHO RESPONDED TO MY TOPIC
Posted: Fri Feb 20, 2009 3:13 am
by uppalapati2003
my problem was solved i am able to read the data using to_char(clob column name)
thnaks all
Posted: Fri Feb 20, 2009 8:24 am
by chulett
Yes, that can work provided you know that the maximum length of the data in the CLOB is less than (or equal to) 4000.
Posted: Fri Feb 20, 2009 9:43 am
by devanars
Is there any issue writing data in to CLOB in oracle!
Posted: Fri Feb 20, 2009 9:58 am
by chulett
Yes, there can be and again it centers around just how much C you need to put into the LOB.
Posted: Fri Feb 20, 2009 6:31 pm
by rohit_mca2003
Please try to use Dynamic RDBMS stage to retrieve CLOB data... select datatype of column as Longvarchar but do not menion any column length... it works for lengthy CLOBs also.
Posted: Mon Feb 23, 2009 9:40 am
by devanars
How can we read from db2 stage if the length is varchar 700.
Posted: Mon Feb 23, 2009 11:01 am
by chulett
You
really need to start your own post for this.
