SourcePro DB : DB Access Module for DB2 CLI User’s Guide : Technical Information : Result Sets : Simultaneous Processing of Results from Multiple Statements Using the Same Connection
Simultaneous Processing of Results from Multiple Statements Using the Same Connection
The DB Access Module for DB2 CLI queries the DB2 CLI library for the maximum number of simultaneously active SQL statements (SQLHSTMT) allowed per connection (SQL_MAX_CONCURRENT_ACTIVITIES). If a connection is used for a new operation, but already has the maximum number of simultaneous operations active, the results of the oldest operation are silently discarded. DB2 CLI allows an indefinite number of active statements per connection, enabling simultaneous processing of multiple statements.