August 25, 2009, 03:37 PM
Pascal BelleroseSET NODATA=(NODATA) not working
Hi,
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:
quote:
Starting Load
0 WARNING.. ON MATCH INCLUDE INPUTS DUPLICATE SEGMENTS
(FOC1400) SQLCODE IS -407 (HEX: FFFFFE69)
: [23502] 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.