DATATYPE CHECK

[CelesteT]

I want to extract data from a sequential flat file and then load the data into an Informix database. Is there a way I can check to ensure the data types integrity from the flat file before passing it through to the database? I understand you can create a constraint in the transformer to reject any records that cannot pass through to the database (for whatever reason). Is there a function where I can check the datatype of the data prior to loading into the database?

Thanx!!!