Error reading files using File Pattern

chandu123 · Post by **chandu123** » Wed Nov 02, 2016 11:15 am

I am reading multiple csv files using Sequential File Stage with File Pattern option. But while reading Datastage is concatenating last record of first file and first record of second file. I think that is because there is no new line character after the last record of first file. How can we address this in Datastage?

Should I set any option in sequential file stage to treat them as separate records?

EX:
F1:
abc
def

F2
xyz
mno

Current Output:
abc
defxyz
mno

Expected:
abc
def
xyz
mno

chulett · Post by **chulett** » Wed Nov 02, 2016 1:39 pm

Can you verify the job type, please? I don't recall Server jobs having a "File Pattern" option in that stage but could be wrong.

chandu123 · Post by **chandu123** » Mon Nov 07, 2016 3:38 pm

Sorry.. updated the job type to 'Parellel'.

chulett · Post by **chulett** » Mon Nov 07, 2016 4:24 pm

... and then moved to the proper forum.