SQLCANCEL( ) Function

Example   See Also

Requests cancellation of an executing SQL statement.

Syntax

SQLCANCEL(nConnectionHandle)

Returns

Numeric

Arguments

nConnectionHandle

Specifies the active connection handle whose SQL statement is to be cancelled.

Remarks

SQLCANCEL( ) returns 1 if the SQL statement is successfully cancelled,  – 1 if there is a connection level error, and  – 2 if there is an environment level error.

SQLCANCEL( ) cancels the execution of SQLCOLUMNS( ), SQLEXEC( ), SQLMORERESULTS( ), and SQLTABLES( ) in asynchronous mode. Use SQLSETPROP( ) to establish asynchronous mode.