SQL Interruption

Informix®

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

Microsoft™ SQL Server

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

Solution

The SQL Server database drivers support SQL interruption and return the Informix error code -213, when the statement is interrupted.