| SQL adaptation guide for IBM Netezza 6.x / BDL programming | |
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.
The Netezza database driver supports SQL interruption and converts the native SQL error 46 to the Informix error code -213.