Hi,
We have a requirement to read a text data which is running in paragraphs with newlines in between. The source is a sequential file. We have defined LongVarChar in DataStage to read this column as the target database will have CLOB datatype for this column. But still when I tried to view the record in the Seq File stage, it puts the record in a disordered way. can any one help me how to read such a record and load the same?
Thanks in advance.
to read a paragraph data(clob datatype)
Moderators: chulett, rschirm, roy
A "disordered way"? You may want to explain what that means.
Sounds like you haven't even gotten to the CLOB part yet. Are you having a problem simply trying to read the file because there are newlines in one field? Move the Columns tab in the Sequential File stage over to the right and change the 'Contains terminators' option for that column to 'Yes', see if that helps...
Sounds like you haven't even gotten to the CLOB part yet. Are you having a problem simply trying to read the file because there are newlines in one field? Move the Columns tab in the Sequential File stage over to the right and change the 'Contains terminators' option for that column to 'Yes', see if that helps...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: