how to handle CLOB datatype in Datastage?

[balaya.ds]

how to handle CLOB datatype in Datastage?

[ArndW]

DataStage doesn't have a CLOB datatype, but databases do. Which database and which interface are you intending on using CLOBs with? Some are supported, some aren't supported and work and some aren't supported and won't work?

[chulett]

An exact search for CLOB here should help answer your question, seeing as how you're not the first person to ask.

[Sreenivasulu]

Supporting CLOB and BLOB datatypes would be a very welcome idea for the future releases.

Regards
Sreeni

[vivekgadwal]

how to handle CLOB datatype in Datastage?

Use LongVarchar(n) datatype within DataStage.

Where "n" depends on what is in the CLOB field. For example, when I had to use this, I enquired the max Characters that could be present in the field and they (DBA) told me it will not be more than 1500 chars in the field. So, I ended up using LongVarchar(2000), just to be on the safe side. It all depends on the size of the data residing within the field on the Database.

Hope this helps...

[chulett]

Something to note... 2000 is not really a 'long' varchar.

[vivekgadwal]

Something to note... 2000 is not really a 'long' varchar.

Yeah, true...I was actually handling 2 CLOB columns - in separate jobs, one with a full receipt image and the other has signature image (which is not that big). The first one was massive (8000-9000 characters) and the second one was very small (1500 chars approximately).

However, I had both fields declared as "LongVarchar" and that is what I was trying to tell the OP :D