ASNCLP - Event Publishing - DROP PUB command

Use the DROP PUB command to delete a publication.

Syntax


>>-DROP PUB--+-----------------+-------------------------------->
             '-INCLUDE HISTORY-'   

>--+-------------------------------+---------------------------><
   +-ALL---------------------------+   
   | .-,----------------------.    |   
   | V                        |    |   
   +---(--PUBNAME--pubname--)-+----+   
   '-FOR PUBNAME LIKE--"predicate"-'

Parameters

ALL

Specify to delete all of the publications for the schema and server set through the SET commands.

PUBNAME pubname

Specifies the name of an publication to delete.

FOR PUBNAME LIKE "predicate"

Specify to delete all publications that match the LIKE statement. The following example shows a LIKE statement:

DROP PUB FOR PUBNAME LIKE "pubname02%"

INCLUDE HISTORY

Specify to delete the publication for the history table when the publication for the base temporal table is deleted.

Example

To delete a publication:

DROP PUB (PUBNAME MYPUB)