How to read Sequential file with columns contain new line

xinhuang66 · Post by **xinhuang66** » Mon Jul 16, 2007 7:39 pm

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".

chulett · Post by **chulett** » Mon Jul 16, 2007 8:43 pm

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

xinhuang66 · Post by **xinhuang66** » Mon Jul 16, 2007 8:46 pm

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

chulett · Post by **chulett** » Mon Jul 16, 2007 9:10 pm

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.

xinhuang66 · Post by **xinhuang66** » Mon Jul 16, 2007 10:40 pm

Thanks, I guess so.

But I just couldn't find it.

sachin1 · Post by **sachin1** » Tue Jul 17, 2007 12:36 am

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