SQL Interruption

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

SQL SERVER 2005 supports SQL Interruption in a similar way as Informix. The db client must issue an SQLCancel() ODBC call to interrupt a query.

Solution

The SQL Server SNC and ESM database drivers support SQL interruption and return the Informix error code -213 if the statement is interrupted.

Important: Make sure you have SQL SERVER 2005 or higher installed and that you use the SNC or ESM database driver.