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.
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'
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.
