Unable to read file through complex flat file stage

[krishna81]

Hi Folks,

How can we read file by giving more than one string as a Record delimiter in CFF stage.

Here is My job flow

Mq --->Seq(Here i am creating file with ~~ as record delimiter)

Reading above file using CFF
CFF --->Peek


Thanks
Krish

[ray.wurlod]

Use Record Delimiter String property rather than Record Delimiter property.

[krishna81]

I did not see Record delimiter string property in CFF stage.We are using 8.0.1 verson.

[asorrell]

Is there any particular reason you are using the CFF stage to read it? I normally use that just to read COBOL data. If you used a sequential file to create the file, why not use a sequential file to read the file?

[chulett]

Yes... what is the C in your FF?

[krishna81]

Yes There is specific reason why i am using CFF stage.I have to split the date based on my record type.

For chulett C is Complex

[ArndW]

Stage -> Record Options -> Record Delimiter.

[chulett]

For chulett C is Complex

That I know. What I was asking was: what is the Complexity of your Flat File? What was driving you to using the CFF stage in other words.

[krishna81]

Here my source is MQ.Because of this i am writing data using Seq file stage and later using CFF to read the same.
The reason i am using CFF is the data iis in hexa and variable length.

Still i am wondering the Record Delimiter String property is not there in CFF stage as Ray mentioned above.

[chulett]

Look again, if it is truly not there then perhaps it was something added in a later version / patch, in which case I would check with your official support provider.

[ray.wurlod]

I'm not able to check now. But the Sequential File stage definitely has it, as does the Column Import stage.

[ArndW]

krishna81 - I think you missed my post.

Stage -> Record Options -> Record Delimiter.