Sequential File --> All Records are coming in a single re

Naren12345babu · Post by **Naren12345babu** » Tue May 10, 2016 3:18 pm

Hi,

I have my source as

AD
TPR
DISPLAY

When I am writing this to sequential File, I am getting output as

AD TPR DISPLAY

The Sequential File Format settings are Final Delimiter = WhiteSpace

I need output as below

AD
TPR
DISPLAY

How can I do this. I am not able to get records one below other.

chulett · Post by **chulett** » Tue May 10, 2016 3:57 pm

These examples are meant to show us three records in the source and target? If so, the final delimiter in the sequential file has no bearing on that aspect of your example, that is controlled by the Record delimiter which is by default to a UNIX Newline from what I recall. What is yours set to? And where exactly are you seeing this output? If you move the file over to Windows first to view it then you could very well see it as a "single record" there because Windows uses a different record delimiter.

Naren12345babu · Post by **Naren12345babu** » Tue May 10, 2016 4:06 pm

I am Seeing this output in Windows.

chulett · Post by **chulett** » Tue May 10, 2016 4:54 pm

With no other answers or details forthcoming, all I can say is "hence the problem". Check it on the UNIX server. Where will this file be consumed, UNIX or Windows? That will drive the settings you should use.

ray.wurlod · Post by **ray.wurlod** » Tue May 10, 2016 5:47 pm

Eliminate your Final Delimiter property and set the Record Delimiter String property (which is different from the Record Delimiter property) to "DOS style". Let us know whether that works.