Show TOC

rs_batch_endLocate this document in the navigation structure

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.