The subscriptions table stores information for all ASE Replicator subscriptions.
Table A-10 lists the columns in the subscriptions table.
Column name |
Datatype |
Description |
|---|---|---|
subid |
numeric(18,0) |
Subscription ID |
name |
varchar(128) |
Name of subscription |
pubid |
numeric(18,0) |
ID of the publication to which this subscription subscribes |
conn_id |
numeric(18,0) |
ID of the replicate connection this subscription belongs to |
status |
smallint |
Status of the subscription |
status_desc |
varchar(255) |
Status description |
Each row in the subscriptions table identifies a single subscription.
When you create a subscription, a row is added to the subscriptions table for the new subscription.
When you delete a subscription, the row that identifies that subscription is deleted from the subscriptions table.
