Toad World® Forums

Cannot cancel executing INSERT statement in Netezza

If I execute a statement in the form of: INSERT INTO TARGET (FIELD1,FIELD2,FIELD3,…) SELECT FIELD1,FIELD2,FIELD3… FROM SOURCE, I’m unable to cancel that statement by clicking the red “cancel execution…” button. I can press the button, but the statement continues to execute. I’m able to abort the transaction using Netezza Administrator.

Can you let me know if you were issuing a command to abort the transaction or you use some tool to abort it?

Thanks!

Netezza drivers ship with an application called “IBM Netezza Administrator”. It allows you to view the health of the server and to also see what select statements are executing on the server. You can kill statements through its interface.

Thank you for the information. I created QAT-2053 for this issue.