I am running with a problem where I am reading a flat file with Seq file stage.
I have a timestamp field with value 11/30/2012.22.05 without seconds values.
I have set the format string in the column definition as "%mm/%dd/%yyyy.%hh.%nn" and reading the field as timestamp.
The values are getting read properly and getting converted to a timestamp value as 2012-11-30 22:05:00
But I just ran the job with value 11a30/2012x22.05 - This should be rejected according to me. But still it passed and the timestamp value remained as mentioned above.
![Shocked :shock:](./images/smilies/icon_eek.gif)
I think Datastage accepting any ASCII character in place of '/' and '.' Anyone who has knowledge on this please spread somelight. I have spent a whole day figuring out how to get it rejected
![Sad :(](./images/smilies/icon_sad.gif)