SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_UNREGISTER_PUBLICATION
  
SYNC_UNREGISTER_PUBLICATION
The SYNC_UNREGISTER_PUBLICATION system stored procedure unregisters a publication.
CALL SYNC_UNREGISTER_PUBLICATION (
  replica_catalog_name, -- WVARCHAR
  publication_name,     -- WVARCHAR
  drop_data             --INTEGER
)
EXECUTES ON: replica.
If drop_data flag is set to a non-zero value, all subscriptions to the publication are automatically dropped.
If replica_catalog_name is NULL, then the current catalog is used.
If there are uncommitted changes, the call will fail with an error.
This system procedure does not return a resultset.
RC
Text
Description
13047
No privilege for operation
 
13110
NULL not allowed
Only the catalog name can be NULL; all other parameters must be non-NULL.
13133
Not a valid license for this product.
 
21xxx
Communication error
Was not able to connect to master. For more details about 21xxx errors, see solidDB® communication errors in the solidDB® Administrator Guide.
25005
Message is already active.
 
25010
Publication not found.
 
25019
Database is not a replica database.
 
25020
Database is not a master database.
 
25023
Replica not registered.
 
25031
Transaction is active, operation failed.
User has made some changes that are not yet committed.
25035
Message is in use.
 
25056
Autocommit not allowed.
You must run this stored procedure with autocommit off.
25071
Not registered to publication.
 
See also
System stored procedures for advanced replication