solidDB Help : solidDB reference : SQL: Statements : ALTER REPLICATION SUBSCRIPTION
  
ALTER REPLICATION SUBSCRIPTION
ALTER REPLICATION SUBSCRIPTION subscription‑name SET {
   PARTITION partition‑name |
   CONNECT TO connect‑name |
   ON CONFLICT conflict‑resolution‑rule |
   table‑mapping‑list |
   automatic‑load |
   SYMMETRICAL |
   IGNORE LOOP}
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER REPLICATION SUBSCRIPTION statement to change subscription settings. The statement is transactional and does not affect a subscription that is already running. In order to change the subscription, the ALTER REPLICATION SUBSCRIPTION statement must be committed first, and then the subscription should be restarted.
Parameters, clauses, keywords, and variables
For descriptions of the following variables, see CREATE REPLICATION SUBSCRIPTION.
▪ subscription‑name
▪ partition‑name
▪ connect‑name
▪ conflict‑resolution‑rule
▪ automatic‑load
▪ table‑mapping‑list
Return values
 
Error code
Description
26022
Incorrect subscription parameter
26033
Failed to alter replication subscription
Example
ALTER REPLICATION SUBSCRIPTION sub1 SET CONNECT TO conn2;
Go up to
SQL: Statements