Records that don't satisfy the specification can be sent to a rejects link.
This is behaviour we appreciate.
But some data that doesn't correspond to the specifications does not result in rejected records, and that is a problem for us. Because some erroneous data goes undetected.
For example: If you have a fixed length record type, you specify that a field has type 'integer' and size 5, then 5 bytes will be read and scanned into the integer field as follows:
Code: Select all
Flat File field data -> DataStage integer value received
-------------------- ---------------------------------------
12345 12345 Correct
123AA 123 Error for me
12 12 Could be seen as an error. Depends.
1A1A1 1 Error for me
Thanks in advance,
Wim