DB2 10.5 for Linux, UNIX, and Windows

SET CURRENT FEDERATED ASYNCHRONY statement

The SET CURRENT FEDERATED ASYNCHRONY statement assigns a value to the CURRENT FEDERATED ASYNCHRONY special register.

This statement is not under transaction control.

Invocation

The statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.

Authorization

None required.

Syntax

Read syntax diagramSkip visual syntax diagram
                                       .-=-.   
>>-SET--CURRENT--FEDERATED ASYNCHRONY--+---+-------------------->

>--+-ANY--------------+----------------------------------------><
   +-integer-constant-+   
   '-host-variable----'   

Description

ANY
Specifies a CURRENT FEDERATED ASYNCHRONY value of -1, which means that the execution of statements can involve asynchrony using a degree that is determined by the database manager.
integer-constant
Specifies an integer value between 0 and 32 767, inclusive. The execution of statements can involve asynchrony using the specified degree. If the value is 0 when an SQL statement is dynamically prepared, the execution of that statement will not use asynchrony.
host-variable
A variable of type INTEGER. The value must be between 0 and 32 767, inclusive, or -1 (representing ANY). If host-variable has an associated indicator variable, the value of that indicator variable must not indicate a null value (SQLSTATE 42815).

Notes

Examples