rs_helppub
Displays information about publications.
Syntax
rs_helppub [<publication_name>, <primary_dataserver>, <primary_db>, <article_name>]
Examples
-
rs_helppub
Publication Name PRS Primary DS.DB ---------------- ------- ------------- funcpub prim_rs P_DS.pdb1 pub1 prim_rs P_DS.pdb1 pub2 prim_rs P_DS.pdb1 Num Articles Status Request Date ------------ ------- ------------------- 3 Valid Mar 23 1998 11:51AM 7 Valid Mar 24 1998 10:41AM 3 Valid Mar 24 1998 11:50AM (return status = 0)
-
rs_helppub funcpub:
Publication Name PRS Primary DS.DB ---------------- ------- -------------- funcpub prim_rs P_DS.pdb1 Num Articles Status Request Date ------------ ------ ------------------- 3 Valid Mar 23 1998 11:51AM Article Name Replication Definition Type ------------ ---------------------------- authors authors authors authors publishers publishers Primary Object Name Replicate Object Name Request Date ------------------ --------------------- ------------------- many_rows_data many_rows_data Mar 23 1998 10:01AM Mar 23 1998 11:51AM Sub Name Replicate DS.DB Owner Req. Date ---------- --------------- ----- ------------------------- funcsub1 R_DS.rdb1 sa Mar 24 1998 11:12AM (return status = 0)
-
rs_helppub funcpub, P_DS, pdb1, publishers:
Article Name Publication Name Replication Definition ------------ ---------------- ------------------------ publishers funcpub publishers Primary Object Name Replicate Object Name -------------------- --------------------- publishers publishers Type Request Date Status ---- -------------- ---------- Table Mar 23 1998 11:51AM Valid Where clauses ---------------------------------------------------------------- where pub_id = "0736" Sub. Name Replicate DS.DB Owner Req Date ---------- --------------- ----- ------------------- funcsub1 R_DS.rdb1 sa Mar 24 1998 11:12AM (return status = 0)
Usage
If rs_helppub is executed at the primary site, information displays for all of the publications created at that site.
If rs_helppub is executed at the replicate site, information is displayed only for publications for which subscriptions have been created at that site.
Use rs_helppubsub to display information about subscriptions to publications or articles.
Use check_subscription to get the most accurate report of subscription status.