END ASYNC OPERATION Statement

Marks the end of a block of statements intended for asynchronous, parallel execution.

Valid in: SPD Server
Explicit SQL pass-through facility
Requirement: Must be used in conjunction with the BEGIN ASYNC OPERATION Statement.

Syntax

END ASYNC OPERATION

Without Arguments

execute (end async operation) by sasspds;

Details

You can maximize the performance of certain SQL statements by specifying to execute them asynchronously, in parallel. SPD Server provides the BEGIN ASYNC OPERATION and END ASYNC OPERATION statements to delimit the block of statements that are intended for asynchronous, parallel execution. The BEGIN ASYNC OPERATION statement marks the beginning of the statement block. The END ASYNC OPERATION statement marks the end of the statement block.
For examples of how the BEGIN ASYNC OPERATION and END ASYNC OPERATION statements are used, see “Creating Asynchronous Operation Blocks” in X.
Last updated: February 8, 2017