DSXchange

How can I read a sequential file with columns contain new line characters ?

The file use another special character as field delimiter and record delimiter. And each time, DS read the column with "New line characters", it will stop reading characters after "new line characters".

What are these other 'special characters' for the field and record delimiters in the file? Have you configured the stage to use them?

Yes, I configured field and record delimiter to use it.

field Delimiter string = \xDC\x20
Record Delimter String = \xD1\x20\x0A

The frustrating thing is each time if the column contains \x0A, it will not continue to read characters after \x0A.

Thanks

There's an option in Server to tell DataStage that a column 'Contains Terminators' and thus treat them as data rather than record delimiters. I would think a similar option would exist in PX... somewhere.

Thanks, I guess so.

But I just couldn't find it.

column terminator can be found in column tabs in sequential file.