Page 1 of 1

Does Datastage 8.7 support CLOB data types?

Posted: Wed Sep 12, 2012 10:14 pm
by mchaves
Hi All,
We are migrating datastage jobs from 8.5 to 8.7 and we encountered an issue with Oracle CLOB fields. Has anyone experienced this? The same job in 8.5 runs flawlessly using the same Oracle CLOB fields.

Well, I'm not expecting to get answer here, but this an alert that 8.7 may have its own issues and not being an enhancement to 8.5 as understood.

inup_S_TTI_EVENT,0: Unsupported data type: 108. (CC_OraDescribeHelper::describeColumn, file CC_OraDescribeHelper.cpp, line 2,322)

Posted: Thu Sep 13, 2012 7:31 am
by chulett
Are you using the Connector? It is one of the "LOB-aware" stages in 8.5 and I don't see why that would have changed in the 8.7 release. Every release has "its own issues" and it sounds like this is one... please let us know what support has to say. :wink:

Posted: Thu Sep 13, 2012 6:17 pm
by mchaves
Hi Chullet,
Yes, this issue occurs with the new oracle connector. Everything tells me it could be an issue with 8.7 as the same job in 8.5 works welll using the same table - we are doing migration. We have a PMR raised. I'll keep you guys informed.