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.