SQL Interruption
Informix®
With Informix, it is possible to interrupt a long running query if the SQL INTERRUPT ON option.
Netezza®
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.
Solution
The Netezza database driver supports SQL interruption and converts the native SQL error 46 to the Informix error code -213.