| SQL adaptation guide For IBM DB2 UDB 8.x, 9x / BDL programming | |
With Informix®, it is possible to interrupt a long running query if the SQL INTERRUPT ON option.
DB2® UDB 9 supports SQL Interruption in a similar way as Informix. The db client must issue an SQLCancel() ODBC call to interrupt a query.
The DB2 database driver supports SQL interruption and converts the native SQL error code -952 to the Informix error code -213.