Unanswered: DB2 on iSeries - UPDATE statement through ODBC on triggered table
I am running an UPDATE command on a table which has an AFTER UPDATE trigger. When the update statement is executed on the SQL screen on iSeries, it executes fine and all records are updated.
If I run the same update through ODBC (using the same user), only the first row it finds is updated. After that I get the error:
"MCH3401 - Cannot resolve to object F0101_SRV. Type and Subtype X'0203' Authority X'0000'."
If I execute the update a second time, a second row is updated before I get the error.
Can anybody suggest why a trigger might cause an error through ODBC only? It works fine on iSeries. If I temporarily disable it, the UPDATE works from both iSeries and ODBC.