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.

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