SQL Interruption

Informix®

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

IBM® DB2®

IBM DB2 supports SQL Interruption: The db client must issue an SQLCancel() ODBC call to interrupt a query.

Solution

The IBM DB2 database driver supports SQL interruption and converts the native SQL error code -952 to the Informix error code -213.