SQL Interruption

Informix®

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

SQLite

SQLite supports SQL Interruption: The db client must issue an sqlite3_interrupt() ODBC call to interrupt a query.

Solution

The SQLite database driver supports SQL interruption and converts the native SQL execution status SQLITE_ABORT to the Informix error code -213.