We have an issue here where we are querying a database that accepts dot (.) as a value for text fields. (DB2 UDB for ISeries - aka DB2 UDB for AS/400)
Unfortunately, Datamigrator interprets a dot as a null value.
So someone at IBI came up with with a solution using the instruction "SET NODATA=(NODATA" and it worked. We were at 7.6.4.
Now we are at 7.6.9 and it does not work anymore. Datamigrator is still seeing a null value.
Here's how it looks in ETLLOG:
Starting Load 0 WARNING.. ON MATCH INCLUDE INPUTS DUPLICATE SEGMENTS (FOC1400) SQLCODE IS -407 (HEX: FFFFFE69) :  Valeurs indéfinies non admises dans la colonne ou la variable IV : CREF. (FOC1416) TRANSACTION ERROR : BIFACPP Commit forced at: 367 for 367 row(s) -- stats for source file 367 : Row(s) processed by job 0 : Row(s) rejected due to format error -- stats for target file: bifacpp 367 : Row(s) processed by job 366 : Row(s) accepted by target table 366 : Row(s) inserted into target table 0 : Row(s) updated in target table 0 : Row(s) deleted from target table 0 : Row(s) rejected due to validation errors 0 : Row(s) rejected due to no match 0 : Row(s) rejected because duplicate exist 1 : Row(s) rejected due to DBMS error
We would like Datamigrator to see a dot as a dot or any other value that expresses a value.
WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2