Error in Excel-to-AS/400 DB2 conversion

Issue: When using a mapping involving an AS400 Database, you may come across this error

Error in SQL Query.[SQL7008] CUS in CONVERT not valid for operation.

Solution:

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.

 


Have more questions? Submit a request

0 Comments

Article is closed for comments.