Flat file

, ,
1

Hai,
How can we set the value of the field as unique in FlatFile schema field definition.And is it right to use the Fixedlength flat file structure to set each and every field with fixed length in a record?

Thanks in Advance,
Viji.

2

“And is it right to use the Fixedlength flat file structure to set each and every field with fixed length in a record”

yes that is true,if your flatfile is a fixed position then choose fixed length option and set each field with fixed length (start and end positions)this makes parsing successfully.Define a sample FFSchema and test it for better understanding.

HTH,
RMG

3

Hai RMG,
Thanks to ur reply.But I want to know how to set the uniqueness of the field in the schema.Thatis that field value should be unique.
And how can we convert the field type to DATE or NUMERIC in the schema.

Thanks
KArupuv

4

For this you have to develop a formatService and assign it in the schema for the particular field that you want to validate.

HTH,
RMG.