Contains Terminators option to handle newlines in Sequential

Theenathayalan · Post by **Theenathayalan** » Fri Mar 20, 2009 1:13 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Mar 20, 2009 4:19 pm

Are the strings in which the newline characters appear quoted?

Theenathayalan · Post by **Theenathayalan** » Sat Mar 21, 2009 11:51 am

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?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 21, 2009 1:39 pm

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

Theenathayalan · Post by **Theenathayalan** » Sun Mar 22, 2009 7:06 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Mar 23, 2009 12:25 am

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

Pagadrai · Post by **Pagadrai** » Mon Mar 23, 2009 1:55 am

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.

sima79 · Post by **sima79** » Mon Mar 23, 2009 4:04 am

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

Theenathayalan · Post by **Theenathayalan** » Mon Mar 23, 2009 12:55 pm

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.

chulett · Post by **chulett** » Mon Mar 23, 2009 3:15 pm

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

DSXchange

Contains Terminators option to handle newlines in Sequential

Contains Terminators option to handle newlines in Sequential

Re: Contains Terminators option to handle newlines in Sequen