Call Level Interface Guide and Reference

Use Multiple Threads rather than Asynchronous Execution

The asyncronous SQL model should only be used on non-threaded operating systems such a Windows 3.1. If your application cannot make use of multi-threading then see Asynchronous Execution of CLI.

Asynchronous SQL should NOT be used on platforms that support multiple threads.

Writing Multi-Threaded Applications describes why and how to make use of multiple threads with DB2 CLI. Some common uses include:

• A thread other than the one executing can be used to call SQLCancel() (to cancel a long running query for example).
• Most GUI based applications use threads in order to ensure that user interaction can be handled on a higher priority thread than other application tasks, such as accessing the database.
• Executing DB2 CLI functions on multiple threads can improve throughput.