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.