how to retrive the data from CLOB Column through datastage

[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

[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.

[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.

[chulett]

Search the forums for "CLOB", it has been discussed here quite a bit.

[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

[uppalapati2003]

my problem was solved i am able to read the data using to_char(clob column name)
thnaks all

[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.

[devanars]

Is there any issue writing data in to CLOB in oracle!

[chulett]

Yes, there can be and again it centers around just how much C you need to put into the LOB.

[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.

[devanars]

How can we read from db2 stage if the length is varchar 700.

[chulett]

You really need to start your own post for this.