rs_helpdbsub

Displays information about database subscriptions associated with the replicate data server.

Syntax

rs_helpdbsub [<db_sub>[, <data_server>[, <database>]]]

Parameters

db_sub: Specifies the database subscription.
data_server: Specifies the data server name whose database subscription you want to display.
database: Specifies the database name whose database subscription you want to display.

Examples

Example 1

In this example, Adaptive Server displays information about a single database subscription, <db_sub1>:

rs_helpdbsub db_sub1, RDS1, rdb1

DBSub.Name  ReplicateDS.DB  ReplicateRS  Status at RRS  DBRep.Def.Name
----------  --------------  -----------  -------------  ---------------
db_sub1     RDS1.rdb1       RRS1         Validate       db_rep

PrimaryDS.DB  PrimaryRS  Method       Trunc.Table     Creation Date
------------  ---------  -----------  -----------     -----------------
PDS.pdb1       PRS        Bulk Create  Yes              May 2 2003 3:38PM

Usage

If you do not specify any parameters, rs_helpdbsub lists database subscriptions defined in the Replication Server.
If you supply the <db_sub> parameter only, rs_helpdbsub lists all the database subscriptions defined in the Replication Server that have a database subscription name matching <db_sub>.
The parameters can contain the wildcard ‘%’. This wildcard represents any string. For example, if a string ‘abc%’ is assigned to <db_sub>, rs_helpdbsub will list all database subscriptions that have a database subscription name prefixed with ‘abc’.