 Re: Async Processing and DB2 V8
Phil Castle wrote:
[color=blue]
> I wonder if anyone can help me with this problem.
> I have an ODBC/CLI application that runs queries against DB2. In order
> to allow my users to cancel an active query, I run the SQL statements
> in async mode. This is done by calling SQLSetStmtAttr with option
> SQL_ASYNC_ENABLE. This has worked fine for years against all DB2s
> between V2 and V7. However this no longer works for users running the
> DB2 V8 Client. Also, I now notice that in the V8 manuals,
> SQL_ASYNC_ENABLE is no longer given as being an valid option for
> SQLSetStmtAttr. Has this functionality been removed from the DB2
> Client, or is something else going on?[/color]
The functionality should still be there for backward compatibility. As far
as I heard (that's not official, mind you!), support for async execution
will be removed is some future version of DB. You might want to move to
threaded applications and use the CLI call "SQLCancel" to interrupt
queries.
That should also be better for your applications because you don't have to
check all the time whether your query is already completed. Once the query
is completed, the thread running the SQLExecute will become unblocked right
away.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
| 
