Hi All,
I want to populate the CLOB datatype thro Mapping. Has anyone know whether DataStage supports such datatypes?
Bala
God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere
CLOB datatype
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Basically, the answer is no.
You can pre-process the object (for example with uuencode) so that it is a character string, which DataStage can handle.
If you think about it, these large object data types are not amenable to ETL - what Transformation even makes sense? If you want to move them from one place to another - assuming those places are compatible in terms of handling BLOB, CLOB and so on - why get DataStage involved?
This topic has been addressed in the past, both on this forum and in datastage-users@oliver.com (archived on this site). Search for CLOB and BLOB for more details about how to do it, if you really must.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
You can pre-process the object (for example with uuencode) so that it is a character string, which DataStage can handle.
If you think about it, these large object data types are not amenable to ETL - what Transformation even makes sense? If you want to move them from one place to another - assuming those places are compatible in terms of handling BLOB, CLOB and so on - why get DataStage involved?
This topic has been addressed in the past, both on this forum and in datastage-users@oliver.com (archived on this site). Search for CLOB and BLOB for more details about how to do it, if you really must.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518