SQL Interruption

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

Netezza® supports SQL Interruption in a way similar to Informix. However, when the statement is interrupted, Netezza rolls the transaction back 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.