Focal Point
SET NODATA=(NODATA) not working

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/182103022

August 25, 2009, 03:37 PM
Pascal Bellerose
SET 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.


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2