DSXchange

Hi All,
We have a tab delimited file having more than 200 columns. some of the records are broken into 2 or 3 rows. we want to capture those bad rows or records. Either in Data stage or in Unix.
We can not use any other delimiter in the file.
Can any one suggest how we can implement this.

Thanks in advance,
Raghuraj

If you know in which fields the line terminator occurs, just mark those columns "contains line terminator" in the Columns grid. DataStage will do the rest.

Which will allow you to read them and thus they will no longer be 'bad'. You can still check the field for terminators after the fact and logically reject them if you like.