SQL Interruption

Informix®

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

PostgreSQL

PostgreSQL supports SQL Interruption: The db client must issue an PQcancel() libPQ call to interrupt a query.

Solution

The PostgreSQL database driver supports SQL interruption and converts the SQLSTATE code 57014 to the Informix error code -213.