SQL Interruption

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

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

Solution

The Genero db database driver supports SQL interruption and converts the native SQL error code -30005 to the Informix error code -213.

Note: Make sure you have Genero db 3.80 or higher installed. Older versions do not support SQL interruption. At this time, Genero db 3.80 does not support interruption of a DDL statement or an SQL statement waiting for a lock to be released (such as SELECT FOR UPDATE). Those limitations should be removed in a later Genero db version.