The CURRENT FEDERATED ASYNCHRONY special register specifies
the degree of asynchrony for the execution of dynamic SQL statements.
(The FEDERATED_ASYNCHRONY bind option provides the same control for
static SQL.) The data type of the register is INTEGER. Valid values
are ANY (representing -1) or an integer between 0 and
32 767,
inclusive. If, when an SQL statement is dynamically prepared, the
value of CURRENT FEDERATED ASYNCHRONY is:
- 0, the execution of that statement will not use asynchrony
- Greater than 0 and less than or equal to 32 767, the
execution of that statement can involve asynchrony using the specified
degree
- ANY (representing -1), the execution of that statement can involve
asynchrony using a degree that is determined by the database manager
The value of the CURRENT FEDERATED ASYNCHRONY special
register can be changed by invoking the SET CURRENT FEDERATED ASYNCHRONY
statement.
The initial value of the CURRENT FEDERATED ASYNCHRONY
special register is determined by the federated_async database
manager configuration parameter if the dynamic statement is issued
through the command line processor (CLP). The initial value is determined
by the FEDERATED_ASYNCHRONY bind option if the dynamic statement is
part of an application that is being bound.
Example: Set the host variable FEDASYNC (INTEGER)
to the value of the CURRENT FEDERATED ASYNCHRONY special register.
VALUES CURRENT FEDERATED ASYNCHRONY INTO :FEDASYNC
DB2 Version 9.7 for Linux, UNIX, and Windows