solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables for replicator : SYS_REPLICATION_SUBSCRIPTIONS
  
SYS_REPLICATION_SUBSCRIPTIONS
The SYS_REPLICATION_SUBSCRIPTIONS table used to store replication subscriptions.
The columns in the SYS_REPLICATION_SUBSCRIPTIONS system table are described in the following table:
 
Column name
Data type
Description
ID
INTEGER
Subscription identifier
SUBSCRIPTION_NAME
WVARCHAR
Unique subscription name
CONNECTION_ID
INTEGER
Connection identifier. Refers to SYS_REPLICATION_CONNECTIONS, see SYS_REPLICATION_CONNECTIONS
PARTITION_NAME
WVARCHAR
Partition name
LOAD_METHOD
VARCHAR
Load method
LOAD_DIRECTION
VARCHAR
Direction of load
CONFLICT_RESOLUTION
VARCHAR
Conflict resolution (TARGET WINS, SOURCE WINS, IGNORE, ABORT SUBSCRIPTION, or ROLLBACK TRANSACTION)
STATUS
VARCHAR
Status of the subscription (INIT, LOAD, STOPPED, ERROR, or ACTIVE)
FLAGS
INTEGER
Internal field
LAST_CONNECTED
TIMESTAMP
Actual time that subscription connected
Go up to
System tables for replicator