User's Manual

Chapter 16. System Objects for Adaptive Server Enterprise
Column Data type Description
filler2 CHAR(255) Reserved
filler3 CHAR(255) Reserved
filler4 CHAR(255) Reserved
sr_subscription table
Function Each row describes a subscription from one user ID (which must have
REMOTE permissions) to one publication.
Columns
Column Data type Description
publication_-
id
INT The identifier for the publication to
which the user ID is subscribed.
user_id INT The user ID that is subscribed to the
publication.
subscribe_by VAR-
CHAR(128)
For publications with a SUBSCRIBE
BY expression, this column holds the
matching value for this subscription.
created NU-
MERIC(20, 0)
The offset in the transaction log at which
the subscription was created.
started NU-
MERIC(20, 0)
The offset in the transaction log at which
the subscription was started.
operation VARCHAR(20)
345