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.

Thanks