ASNCLP - SQL Replication - DROP REGISTRATION command

Use the DROP REGISTRATION command to drop one or more registrations.

Syntax


                                              .-,---------------------.      
                                              V                       |      
>>-DROP REGISTRATION--+-----------------+--(----+----------+--objname-+--)-><
                      '-INCLUDE HISTORY-'       '-objowner-'

Parameters

objowner.: Specifies the owner of the source object (table, view, or nickname) for which you want to drop the registration.
objname: Specifies the name of the source object (table, view, or nickname) for which you want to drop the registration.
INCLUDE HISTORY: Specify to delete the registration for the history table when the registration for the base temporal table is deleted.

Usage notes

The SET DROP command affects whether associated table spaces of the CD tables will be dropped when the objects are dropped.
If the object is a view, only the CD views are dropped.
For nicknames, this command does not drop the associated table spaces.

Example 1

To drop the registration for DB2ADMIN.STAFF:

DROP REGISTRATION (DB2ADMIN.STAFF)

Example 2

To drop the registration for DB2ADMIN.STAFF and DB2ADMIN.EMPLOYEE:

DROP REGISTRATION (DB2ADMIN.STAFF, DB2ADMIN.EMPLOYEE)