Error updating an IDMS table

When updating an IDMS table you may get the following error:

25000(-4)[CA][CA IDMS ODBC Driver][CA IDMS]DB001005 T17172 C-4M321: Invalid transaction state

To resolve this:

• go to Options > Technical Parameters
• de-select Auto Commit
• de-select Uncommited Read
• select Use SQLExecDirect