solidDB Help : solidDB reference : SQL: Statements : STOP REPLICATION
  
STOP REPLICATION
STOP REPLICATION {SUBSCRIPTION subs‑name | FROM CONNECTION conn‑name | ALL}
Access requirements
SYS_REPLICATION_ROLE role
Usage
Use the STOP REPLICATION statement to stop a replication subscription; both online replication and data load.
Return values
 
Error code
Description
26020
Source already stopped
26017
Could not find subscription
Example:
solsql> start replication subscription sub1;
RESULT
------
SUBSCRIPTION_NAME LOG_POSITION STATUS ERROR_CODE ERROR_MESSAGE
================== ========================================== ================== ========== ==================
'SUB1' '000000000000000CFFFFFFFF000001B9000001B9' 'ACTIVE' 'NULL 'NULL

1 rows fetched.

solsql> describe replication subscription sub1;
RESULT
------
Subscription: SUB1
     Connect to: CONN1
     Partition: SHARE1
     Load method: TRUNCATE FROM SOURCE
     On conflict: ABORT SUBSCRIPTION
     Last connected: 2016-09-04 21:39:26
     Status: ACTIVE

1 rows fetched.


solsql> stop replication subscription sub1;
RESULT
------
TXT
==================

1 rows fetched.

solsql> describe replication subscription sub1;

RESULT
------
Subscription: SUB1
     Connect to: CONN1
     Partition: SHARE1
     Load method: TRUNCATE FROM SOURCE
     On conflict: ABORT SUBSCRIPTION
     Last connected: 2016-09-04 21:39:26
     Status: STOPPED

1 rows fetched.
Go up to
SQL: Statements