DSXchange

Hi

I know how to handle newlines appearing inthe column datavalues in the seq. file stages in DS Server.

How to achieve this in DS parallel jobs Seq. file stage.

Is there anyother way to handle newlines in data.

Thanks
Theena

Are the strings in which the newline characters appear quoted?

No..The strings are not quoted in the input...

I was able to handle it in Server jobs. The Seq. file has contains terminator option in the columns tab.

But I could not find it in Parallel jobs.


Is this option present or any other option to acheive this?

You could always use a server Sequential File stage in a server shared container in your parallel job.

Ok..Thanks..Will try that..

Is there any other option to handle newlines in the input columns in the file data in parallel jobs....


Thank you

None of which I am aware. Others may educate us.

Hi,
What are your column and row delimiter values.?
If they are other than new line character, I think you can handle
new line values in columns easily.
Do let us know.

As Pagadrai mentioned, you will need to alter your record delimiter. This usually means altering the process that creates your sequential file. You may not have the ability to change the format. If you do choose an ascii character for your record delimiter that is unlikely to occur in your data e.g. Char(204).

Hi..

The column delimiter is ~
The row delimiter is unix newline character.

Some columns are text columns that contains newlines as datavalue.

Actually we are redesigning our server jobs to parallel jobs.
Server jobs - Sequential file has "Contains terminator option" which is being used.

Parallel jobs - Seq. stage does not have this option.

We cannot ask the source system to change the row delimiter.

You don't need to. However, you should ask the source system to properly quote any string values.