Statement Execution (Reference)

Go Up to Change Views (Reference)

Once a statement is prepared, it is unnecessary to re-prepare the statement due to subscription activation or deactivation. A statement dynamically adjusts to the subscription environment of the transaction when it begins execution. Statement execution is also consistent in that once it begins, it returns change view result sets even if the subscription is deactivated before the full resultset has been fetched.

See Statement Execution for a complete explanation of how the Statement Execution feature works.