Hi,
I have a requirement where I have to fectch column from oracle database having CLOB datatype... I wanted to know that can i directly read the column in datastage ...or I have to use some other method..Please advise...
Handling CLOB datatype in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have your SQL split the CLOB into n columns of VarChar(2000) each and then use either a transform stage or Column Import stage to concatenate the list of VarChar columns into one large one.
This method is being used on my current project because we have CLOBs and BLOBs of up to 60Kb (very wordy XML) and have no choice but to store it in Oracle. This is very unwieldy and, if there is any way for you to avoid it, you should use supported datatypes.
This method is being used on my current project because we have CLOBs and BLOBs of up to 60Kb (very wordy XML) and have no choice but to store it in Oracle. This is very unwieldy and, if there is any way for you to avoid it, you should use supported datatypes.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Note that 4000 is bytes. If you are using NLS then the number of characters displayable in 4000 bytes is less and will cause the job to abort.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I have the similar kind of requirement. I need to load a field in Oracle having CLOB datatype. While reading from source, I am using LongVarchar(2147483647). because the length can be 2147483647 bytes.
But while loading into table using upsert in Oracle Enterprise stage, getting error like SQLCODE - 1480.
While trying to load using LOAD method, giving error saon CLOB datatype not supported...like "main_program: Unsupported SQL type CLOB or NCLOB for column MEMO1."
Can you please suggest?
Thanks,
Nasimul
But while loading into table using upsert in Oracle Enterprise stage, getting error like SQLCODE - 1480.
While trying to load using LOAD method, giving error saon CLOB datatype not supported...like "main_program: Unsupported SQL type CLOB or NCLOB for column MEMO1."
Can you please suggest?
Thanks,
Nasimul