SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / BDL programming |
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.
The SQL Server SNC and ESM database drivers support SQL interruption and return the Informix error code -213 if the statement is interrupted.