Error SQL7008 while updating a DB2/400 table

When updating a DB2/400 table you can get error

SQL7008 -(table) in (file) not valid for the operation

This occurs because the table you are trying to update is not being journalled, and your update is being run within a transaction.

There are a number of ways of resolving this problem:

• switch off Options > Run SQL > Safe Update Mode. When Safe Update mode is selected, AQT will run Updates and Deletes within a transaction.
• ensure Options > Technical Parameters > Auto Commit is checked.
• if you are using DB2/Connect, ensure that AutoCommit is set to Yes. This is configured with the DB2 Configuration Assistant.
• If you are using DB2 Client Access Express, set the Commit mode to Commit immediate (*NONE ). This is configured on the ODBC Configuration for your Datasource.