CFF stage

sandeepgs · Post by **sandeepgs** » Fri Jun 01, 2012 3:51 pm

Hi,

Can we read a delimited separated file using CFF stage.

If YES please let me know how.

Thanks In Advance.

Regards,
Sandeep.

chulett · Post by **chulett** » Fri Jun 01, 2012 4:03 pm

You might want to explain what "delimited separated" means as those two words are basically synonymous in the context of a sequential file. Can you be more specific?

Also - if the file isn't "complex", i.e. isn't EBCDIC or have OCCURS or REDEFINES or packed decimal fields (etc), then you probably should just stick with the normal Sequential File stage.

sandeepgs · Post by **sandeepgs** » Fri Jun 01, 2012 10:22 pm

Hi Chulett,

Thanks for your response.

Yes i am getting a text file as a delimited separated ( Pipe Line : |) and format of records are as defined below.

Ex:

H|1|2|3|4|5
I|1|2|3|4|5|6|7|8
I|1|2|3|4|5|A|B|C
H1|2|3|A|B
I|1|2|3|4|5|A|B|D

So I want to read the set of records which are as defined above in a sequential order i.e. different formats of records which out changing the order of read.

I am trying to use CFF as it can assist multiple record format read and was able to read the records as Fixed width but where as not a delimited separated.

Please check and suggest me better approach of designing this requirement.

Regards,
Sandeep