Two things:

1.  Ensure the AS400 table is being journaled if it is to be updated. 

2.  Make sure the odbc setup ‘Use blocking with a fetch of 1 row’ is unchecked; Performance tab, advanced button.