As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I have a data flow with Delimited flat file as source. One of the attributes is a date for which I want to be checked if it is a correct date which is defined as follows: FIELDNAME=KLANTDATUMBEGIN, USAGE=YYMD, ACTUAL=A10, MISSING=ON, $
A sample source file has 9 lines, and in the second line this field has value 'AA14-10-09' so an incorrect date.
When running the data flow it correctly gives the following error message in the DM log file:
(FOC1346) : FORMAT ERROR: Record 2 , Column 420 (FOC1130) FORMAT CONVERSION ERROR FIELD/KEY : KLANTDATUMBEGIN
This happens at the following code in the flow: SQL EXECUTE SQLIN; TABLE ON TABLE HOLD AS SQLIN FORMAT INTERNAL IF RECORDLIMIT EQ &STOPAT END
Despite this format error &FOCERRNUM still has value 0, so the flow just continues, skipping those input errors but processing the other records.
This is not the behaviour I want, I want to be alerted of any error so I can take proper action. How can I catch this error in the flow?This message has been edited. Last edited by: Tamra,
WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster