skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Informix Wire Protocol Driver : Connection Option Descriptions : Cancel Detect Interval
  
Cancel Detect Interval
Attribute
CancelDetectInterval (CDI)
Purpose
Determines whether long-running queries in threaded applications can be cancelled if the application issues a SQLCancel.
This connection option can affect performance. See Performance Considerations for details.
Valid Values
0 | x
where:
x
is the number of seconds the driver waits before checking for SQLCancel calls.
Behavior
If set to 0 (None), the driver does not allow long-running queries in threaded applications to be canceled, even if the application issues a SQLCancel.
If set to x (seconds), for every pending query, the driver checks for SQLCancel calls at the specified interval. If the driver determines that a SQLCancel has been issued, the driver cancels the query.
Example
If you specify 5, for every pending query, the driver checks every five seconds to see whether the application has issued a SQLCancel call. If it detects a SQLCancel call, the driver cancels the query.
Default
0 (None)
GUI Tab
Advanced tab
See also
*Performance Considerations