rs_batch

rs_batch_end allows users to batch commands into non-Adaptive Server database servers. This function string stores the SQL statements needed to mark the end of a batch of commands.

Examples

Example 1 – Alters rs_batch_end function string so that the SQL output of the function-string class sqlserver_derived_class is END.
```
alter function string publishers.rs_batch_end
for sqlserver_derived_class
output language
'END'
```

Usage

The rs_batch_end function has function-string class scope.
This function string is used with rs_batch_start.
rs_batch_end is sent to the replicate data server as the last command in the batch of commands. It is sent only if use_batch_markers is set to on.
rs_batch_end precedes rs_commit in the order of data server processing.
rs_batch_start, a batch of commands, and rs_batch_end may be repeated for a given transaction if more than one batch is required due to commands being flushed by limits such as dsi_cmd_batch_size.