DSXchange

[quote="DSguru2B"]24 must be the limit on the sequential file stage when you hit view data.[/quote] Thanks DSguru2B, but I have set the Limit to 1000. The display still only shows 24. They are also 24 from various places on the file, not just the first 24 rows. I put in a peek and the outp...

Thanks Ray. The Sequential file is being written as output from a Join Stage. The input to the join stage is 4 seperate datasets - all the same layout. I tried setting format record delimiter to UNIX new line, but no luck. The other odd thing is that there are 601 rows input, and the stats show 601 ...

Hi ArndW, The file when viewed in vi contains all kind of junk like: "0^M" - I was expecting "0" - EDITED: checked the input and there are control characters where-ever the ^M appears. The stuff below is still a mystery though. and ^@28/12/2003^F^@137064^B^@NA^B^ where I would ha...

Hi kumar_s, Thanks for your reply, and for the welcome! :) The meta data is definately the same. When I view the file in the Server job all the columns are displayed, but the data seems to spill over into the next rows. The file is on the same server - it might help to tell you that I used a join st...

Hello Everyone, I have searched the forum and could not find this specific problem, so if anyone can help out, that would be much appreciated. I have a Parallel job which ends up creating a sequential file with the following Format settings: Final Delimiter: None Delimiter: Comma Quote: Double This ...