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.