a flat file with a field value null, e.g.
In the example the 3rd filed is null, i want this file to fail the validation against Schema, but it still pass through and not suspended even if the "Min Occurs" for this field is set to 1.
Then i found out the Min Occurs is not checking for full, it's just check the field is there or not.....
How should i do to make a field become a required one and suspend the file if the field is null?
The minOccurs attribute only checks for the existence of the node, not the content.
To create a constraint against the node content you need to derive your own types
e.g.<element name="EmailAddress type="non-empty-string"/><simpleType name='non-empty-string'> <restriction base='string'> <minLength value='1'/> </restriction></simpleType>
how can we know what are the mandatory fields in flat file schema?
from the about converstion i understand the u dont want to "null" string value in the field, if that is the case then use Reg Expression to reject this value..
i had a text file in that fields are like emp name,emp address,emp city,emp id.now using flat file schema wizard. so how could i know in those what fields should be mandatory and which fields should i have to skip?
could any body help me please!