Chapter 4: ASE Replicator Procedures

sp_helppub

Returns information about publications.

sp_helppub [info|empty]

sp_helppub {info|arts|unsub}, pub_name

info: The keyword that requests information for all publications or for the specified publication.

empty: The keyword that requests information about all empty publications (publications with no articles) in all primary database connections.

arts: The keyword that requests information about all primary articles in the specified publication.

unsub: The keyword that requests information about all primary articles in the specified publication, for which there are no subscribers.

sp_helppub

Returns information about all publications for all primary database connections.

Using sp_helppub with no keyword is functionally identical to specifying only the info keyword.

sp_helppub info, pubdoc

Returns information about the publication pubdoc.

sp_helppub unsub, pubdoc

Returns information about all primary articles for which there are no subscribers in the publication pubdoc.

When listing information about publications, the following result set is returned:

**Table 4-19: ASE Replicator publication information**
Column	Datatype	Description
ds	sysname	Name of the local primary data server
db	sysname	Name of the local primary database
pub_name	sysname	Publication name

When listing information about primary articles in publications, the following result set is returned:

**Table 4-20: ASE Replicator publication articles**
Column	Datatype	Description
ds	sysname	Name of the local primary data server.
db	sysname	Name of the local primary database.
pub_name	sysname	Publication name.
owner	sysname	Owner of primary article.
part_name	sysname	Name of primary article.
proc_num	smallint	Stored procedure group number. If only one procedure exists, then proc_num=1. Tables are proc_num=0.
art_type	varchar(9)	Type of article: table procedure
numsubscribers	int	Number of replicate articles that subscribe to this primary article.
shadow_table	sysname	Name of the shadow table for this primary article.

When sp_helppub is invoked with no keyword, it returns information about all publications for all primary database connections.
When you invoke sp_helppub and specify the info keyword, the publication name (pub_name) is optional.
When you invoke sp_helppub and specify the empty keyword, you cannot specify a publication name (pub_name).
When you invoke sp_helppub and specify the arts or unsub keyword, the publication name (pub_name) is required.
When an error occurs, an error message is returned.