Page 1 of 1
How does DataStage handle CLOB datatypes ?
Posted: Tue Mar 17, 2009 5:30 pm
by arvindps
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.
Posted: Tue Mar 17, 2009 6:27 pm
by ray.wurlod
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.
Posted: Tue Mar 17, 2009 8:26 pm
by Aggie99
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
Posted: Tue Mar 17, 2009 9:22 pm
by ray.wurlod
... and that means that the DRS stage supports LongVarChar, not CLOB.
Posted: Tue Mar 17, 2009 11:06 pm
by Aggie99
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.
Posted: Thu Mar 19, 2009 11:45 am
by arvindps
Thank you for the help guys
Posted: Tue Jun 23, 2009 6:56 am
by CLOPES
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.