DSXchange

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

Use Record Delimiter String property rather than Record Delimiter property.

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

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?

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

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

Stage -> Record Options -> Record Delimiter.

krishna81 wrote: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.

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.

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.

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

krishna81 - I think you missed my post.

ArndW wrote:Stage -> Record Options -> Record Delimiter.