FlatFileSchema-Field Type

, ,
1

Hi,
i am trying to create a flat file schema in 6.1,can u plz tell me how to give the field type(like Alpha,Alphanum,Num).
i didnt mention the field types.
when doing the testing without mentioning the field types i am getting the error like"Unrecognized element".
i dont know whether that is bcoz of Filed type or something else.
can u plz explain.

thanks,
vidya.

2

This problem might be coming because of Unrecognized record identifier.

Please search on wmUsers for recordWithNoID, you will get lot of information regarding this.

3

we do not have a “Data type” in the flat file schema, as all the fields are treated as characters of the specified length.

HTH
Bhavani

4

Or you can have field delimiters to retrieve data from the file.

5

Hi sri
“when doing the testing without mentioning the field types i am getting the error like"Unrecognized element”.

we dont specify any field types in the flat file schema as mentioned in the previous posts.
the error u have encountered is nothing to do with field type i guess.
if u are using flat file adapter …check if u have specifyed all the record identifiers (if fixed length) or deliemeter for records and fields (if deliemited file) and perform the testing …
HTH

sri