DSXchange

The incoming source data column datatype is CLOB. How in datastage we can read that data as we have the option to read it as LONGVARCHAR. But the target table (DB2) expects the column datatype to be CLOB. Is there any option in Datastage to read the CLOB data so that the transformed data can be loaded to the target DB2 table with CLOB datatype

What happened when you tried to load the data? Note that CLOBs (or really any kind of LOB) are not supported, so don't look for any 'official' mechanism.