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.
The execution of the query will not be atomic
Moderators: chulett, rschirm, roy
The execution of the query will not be atomic
Thank you,
Anu
Anu
I would suggest talking to your DBA. Here is an explanation of that error.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: The execution of the query will not be atomic
It is solved as there is FK relationship on the table to itself and it is entering loop. That FK is not indexed. But after indexing it it is resolved.