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.
How does DataStage handle CLOB datatypes ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: