DSXchange

Hi,

Can we read a delimited separated file using CFF stage.

If YES please let me know how.

Thanks In Advance.

Regards,
Sandeep.

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.

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