Hi,
Can we read a delimited separated file using CFF stage.
If YES please let me know how.
Thanks In Advance.
Regards,
Sandeep.
CFF stage
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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