Page 1 of 1

DATATYPE CHECK

Posted: Tue Aug 31, 2004 4:20 pm
by 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!!!