SQL client applications access CONNX Embedded SQL for Adabas using supplied client support libraries that are linked with the SQL application. These client support libraries also provide support for threaded SQL applications. This section explains what this means, and how to write such an application.

An SQL application can have one or more users. In the case of a commercial application that is accessible across a network (internet or intranet), the normal situation requires the application to service the needs of many users. So how does an SQL application manage all these users, or keep track of what they are doing?

In addition, an SQL application may have multiple threads executing in parallel, in order to perform the task efficiently and quickly. The number of users trying to access an application at any given time can be greater than or less than the number of threads available to the application. How does an application manage its threading resources in order to manage the workload from the user population most efficiently?

CONNX Embedded SQL for Adabas provides client support for threaded SQL applications by implementing the concept of the SQL Context for managing users in a threaded environment.