ASNCLP - SQL Replication - DROP STMT command

Use the DROP STMT command to drop SQL statements from an existing subscription set.

Syntax


>>-DROP STMT -FROM--SETNAME--setname--APPLYQUAL--applyqual------>

                                  .-,----------.      
                                  V            |      
>--+----------------+--NUMBER--(----stmtnumber-+--)------------><
   '-SETTYPE--+-R-+-'                                 
              +-U-+                                   
              '-P-'

Parameters

SETNAME setname

Specifies the subscription-set name.

APPLYQUAL applyqual

Specifies the Apply qualifier for the subscription set.

SETTYPE

Specifies the subscription-set type.

R: Specifies a read-only set. This is the default.
U: Specifies an update-anywhere set.
P: Specifies a peer-to-peer set.

NUMBER stmtnumber

Specifies the statement number to drop. You can specify multiple numbers using commas and parentheses.

Usage notes

You cannot drop statements that are added to a subscription set for heterogeneous replication. These statements have the value G for the BEFORE_OR_AFTER column of the IBMSNAP_SUBS_STMTS table.

Example

To drop a statement from the subscription set SET00:

DROP STMT FROM SETNAME SET00 APPLYQUAL AQ00 NUMBER (5)