How does DataStage handle CLOB datatypes ?

arvindps · Post by **arvindps** » Tue Mar 17, 2009 5:30 pm

I have a table that has a CLOB datatype and when I tried to load the table into my warehouse, it gave me an error. The error it gave me was a Parallel job routine (code 134) . Apparently I figured out that DataStage doesn't like CLOB datatypes.

Please help me out and suggest me the steps on how to go about solving this issue.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 17, 2009 6:27 pm

Welcome aboard.

Fastest answer is usually obtained via Search (in menu at top) - others have usually encountered any problem, and may even have solved it.

You are correct that CLOB is not a data type supported by DataStage; most solutions treat these columns as if they were large VarChar data types.

Aggie99 · Post by **Aggie99** » Tue Mar 17, 2009 8:26 pm

the DRS stage supports CLOB. You define it as LongVarChar with a lenght. The lenght is used to allocate memory to hold the CLOB data, as it implies, it could use up a lot of memory.

-aggie

ray.wurlod · Post by **ray.wurlod** » Tue Mar 17, 2009 9:22 pm

... and that means that the DRS stage supports LongVarChar, not CLOB.

Aggie99 · Post by **Aggie99** » Tue Mar 17, 2009 11:06 pm

DRS can read and write CLOB datatype stored in database. In DRS stage, the datatype for the CLOB field is LongVarChar. That's how datastage handle it, as far as what I have been able to do to take CLOB data from one database source to another.

arvindps · Post by **arvindps** » Thu Mar 19, 2009 11:45 am

Thank you for the help guys

CLOPES · Post by **CLOPES** » Tue Jun 23, 2009 6:56 am

that's TRUE.
We insert CLOB using DRS stage with type longvarchar 10000000.
Extract faster, load faster and read faster too if you use an OCI to read other columns in another job.