Show TOC

rs_sqldmlLocate this document in the navigation structure

A replicated function that carries SQLDML to Replication Server.

Examples
Example 1
Sends SQLDML to Replication Server as a stored procedure named rs_sqldml:
create proc rs_sqldml
   @rs_operator char(1),
   @rs_status int,
   @rs_insert_column varchar(16384),
   @rs_from varchar(16384),
   @rs_where varchar(16384),
   @rs_set varchar(16384),
   @rs_select varchar(16384),
   @rs_owner varchar(255),
   @rs_object varchar(255),
   @rs_rowcount int
where:
  • <rs_operator> – any of:
    • U – update

    • D – delete

    • I – insert select

    • S – select into

  • <rs_object> – the operated table name

  • <rs_owner> – the operated table owner. If the owner status of the table is off, owner name will be null.

  • <rs_category >– the SQLDML category:
    • C1 – statements that can be applied at any replicated database and will generate identical result set.

    • C2 – statements that can be applied only at warm standby or MSA database to generate identical result set.

  • <rs_status> – the SQLDML status.

  • <rs_set> – the set clause in an UPDATE statement

  • <rs_where> – the where clause

  • <rs_select> – the select clause in an INSERT SELECT or SELECT INTO statement

  • <rs_from> – the from clause in an INSERT SELECT or SELECT INTO statement

  • <rs_insert_column> – the column list of an INSERT SELECTstatement

  • <rs_rowcount> – the number of impacted rows, which is available only at the end of rs_sqldml.

Usage
  • rs_sqldml is sent to Replication Server as a replicated function. If a SQLDML does not have a responding clause, the parameter will be set to null.

  • SELECT INTO cannot be executed inside a user-defined transaction and is replicated as a system transaction.

  • RepAgent sends both rs_sqldml and its affected row log records to Replication Server, and Replication Server decides whether to apply SQLDML or the affected rows to a target.

  • Adaptive Server logs execbegin rs_sqldml to indicate the beginning of a SQLDML, an execend rs_sqldml to indicate the ending of a SQLDML. SQLDML is packed inside the execbegin command. <@rs_rowcount> is packed inside execend command.

  • To prevent log SQLDML that changes less than SQLDML replication threshold rows, Adaptive Server performs deferred logging for execbegin. It does not log execbegin when a SQLDML until it changes more than the threshold rows. RepAgent flags the first log record of a SQLDML.

  • SQLDML deferred logging is not required. A non-Adaptive Server replication agent, for example, may not perform deferred logging.