I have a workflow that reads XML data from a table, parses into specific formats and writes to a DB2 table on an iSeries. The workflow message shows that all the records are written. When using the Quote SQL version, everything appears to run fine, (shows 62 records written) but I get 0 records in the table. When I change the SQL to None, it writes one record, but then keeps 'running' and locks the table for update.
This may have something to do with commitment control, which is required for all SQLs on our system. I removed the triggers from the table, thinking that is what was causing the problem, but am still having the same issue. One record and locked and Alteryx workflow keeps running, or 0 records and workflow finishes fine.
Note, I am using standard ODBC connection set up for our extracts, not built-in DB2 connections, which is always rejected due to security. I'm waiting for IBM to send link to sign on (too many years without signing on) so I can download latest drivers, which may help?
I've attached messages for both Quoted and non-Quoted flows and lock still on the table long after ending the job in Alteryx.
