com.menten.ieffect.mapper.db.engine.write.DataTargetException, SQL state [38501]; error code [-443]
Problem
In a mapping where datasets are written to a DB2 table, the SQL error described above may occur if there is a trigger program attached to the table that cannot be found.
Reason
The reason is the use of the "native" DB2 driver without specifying a library list in the URL.
Solution
The following change can be made in the file /i-effect/V2r9m0/mapper/db/preferences.xml":
BEFORE:
<url>jdbc:as400://mapmam;driver=native;naming=sql;date format=iso;translate binary=true</url>
AFTER:
<url>jdbc:as400://mapmam;naming=sql;date format=iso;translate binary=true</url>