SQL Collection Agent Transaction Behavior - Batch

Emits

The agent emits commands changing the state of the file currently processed.

Command

Description

Begin Batch

The agent will emit beginBatch before the first UDR from the result set is routed into the workflow.

End Batch

The agent will emit endBatch after the last row in the result set has been mapped to a UDR and routed into the workflow.

Retrieves

The agent retrieves commands from other agents and based on them generates a state change of the file currently processed.

Command

Description

Hint End Batch

When hintEndBatch is called the agent will call endBatch followed by beginBatch (if more records exists in the result set). It will then continue to process the result set.

Cancel Batch

Cancel Batch is not supported by the agent.