SQL Interruption

Informix®

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

SAP HANA®

SAP HANA supports SQL Interruption: The db client must issue an SQLCancel() ODBC call to interrupt a query.

Important:

With SAP HANA, when an SQL statement is interrupted, the complete SQL transaction is rolled back: SAP HANA will cancel the SQL statements executed in the transaction before the interrupted SQL statement.

Solution

The SAP HANA database driver supports SQL interruption and converts the native SQL error code -139 to the Informix error code -213.

If your application allows SQL interruption in transaction blocks delimited by BEGIN WORK / COMMIT WORK, the code needs to be reviewed, because SQL statements prior to the interrupted SQL statement will be rolled back.