Replication subscriptions statements
Use the following SQL statements to manage replication subscriptions:
▪ LIST REPLICATION SUBSCRIPTIONS, see
LIST
All the subscription related commands except DESCRIBE are transactional, they must be committed in order to have an effect and be persistent.
The following example shows a set of commands (and associated output) that create, describe, and then drop a subscription:
solsql> CREATE REPLICATION SUBSCRIPTION sub1 PARTITION share1 CONNECT TO conn1;
RESULT
------
0 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:
Status: INIT
1 rows fetched.
solsql> drop replication subscription sub1;
RESULT
------
0 rows fetched.
Go up to