Contents Index SYSREMOTEUSER table SQL Remote system views

SQL Remote User's Guide
  System Objects for Adaptive Server Anywhere
    SQL Remote system tables

SYSSUBSCRIPTION 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 UNSIGNED INT The identifier for the publication to which the user ID is subscribed.
user_id UNSIGNED INT The user ID that is subscribed to the publication.
subscribe_by VARCHAR(128) For publications with a SUBSCRIBE BY expression, this column holds the matching value for this subscription.
created NUMERIC(20, 0) The offset in the transaction log at which the subscription was created.
started NUMERIC(20, 0) The offset in the transaction log at which the subscription was started.

Contents Index SYSREMOTEUSER table SQL Remote system views