Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 16. System Objects for Adaptive Server Enterprise
Column
Description
log_sent
The log offset for the most recently sent operation.
confirm_sent
The log offset for the most recently confirmed opera-
tion from this subscriber.
tion from this subscriber.
send_count
How many SQL Remote messages have been sent.
resend_count
Counter to ensure messages are applied only once at
the subscriber database.
the subscriber database.
time_received
The time the most recent message was received from
this subscriber.
this subscriber.
log_received
The log offset in the subscriber’s database for the op-
eration most recently received at the current database.
eration most recently received at the current database.
confirm_received
The log offset in the subscriber’s database for the most
recent operation for which a confirmation message has
been sent.
recent operation for which a confirmation message has
been sent.
receive_count
How many messages have been received.
rereceive_count
Counter to ensure messages are applied only once at
the current database.
the current database.
sr_subscriptions view
Function
Each row lists information about a subscription.
Columns
Column
Description
publication_name
The name of the publication to which the user ID is
subscribed.
subscribed.
user_name
The user ID that is subscribed to the publication.
subscribe_by
For publications with a SUBSCRIBE BY expres-
sion, this column holds the matching value for this
subscription.
sion, this column holds the matching value for this
subscription.
created
The offset in the transaction log at which the subscrip-
tion was created.
tion was created.
started
The offset in the transaction log at which the subscrip-
tion was started.
tion was started.
349