The execution of the query will not be atomic
Posted: Wed Apr 16, 2014 12:19 pm
I am trying to perform Delete statement on DB2 (on mainframe).
Job Design.
Dataset -> Xfmr -> DB2 CONNECTOR
I am deleting based on PK ID. I am getting a message as mentioned below.
The execution of the query will not be atomic because the database server does not support atomic operations for non-insert queries
The job is taking forever and not deleting any records. How can I solve the issue.
Job Design.
Dataset -> Xfmr -> DB2 CONNECTOR
I am deleting based on PK ID. I am getting a message as mentioned below.
The execution of the query will not be atomic because the database server does not support atomic operations for non-insert queries
The job is taking forever and not deleting any records. How can I solve the issue.