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.