SQL Interruption


With Informix, it is possible to interrupt a long running query if the SQL INTERRUPT ON option.


Netezza supports SQL Interruption: The db client must issue an SQLCancel() ODBC call to interrupt a query.

Important: When the statement is interrupted, Netezza issues an automatic ROLLBACK and returns a "Transaction rolled back by user", SQL error number 46.


The Netezza database driver supports SQL interruption and converts the native SQL error 46 to the Informix error code -213.