Archives of the TeradataForum

Message Posted: Tue, 28 Mar 2006 @ 15:18:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If the user of this app wants to cancel the query themselves - as opposed to using a Monitor application do it for them - then you will need to execute your queries in Async mode.

Exactly how you do that will depend on what API you are using.

If you use the low level ODBC API I can give you the details (or you can refer to the ODBC user guide) but basically your SQLExecute() [or SQLExecDirect()] call is performed within a loop, and you check to see if the user has requested a cancel. If so you issue an SQLCancel() [ONCE only] and CONTINUE TO LOOP. (Loop ends when you no longer receive 'SQL_STILL_EXECUTING')

In ADO I think there is an Async switch, and a Cancel method.

Dont remember with RDO.

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>