Chapter 4: ASE Replicator Procedures

sp_helpprimaryart

Returns information about primary articles.

sp_helpprimaryart [info]

sp_helpprimaryart {info|pubs}, pri_art 
	[, {conn=conn_name|pub=pub_name}]

sp_helpprimaryart fields, pri_art, {conn=conn_name|pub=pub_name}

info: The keyword that requests information about all primary articles in all primary databases, or information about a specified primary article in a specified primary database or publication.

fields: The keyword that requests field information for a specified primary article in a specified primary database or publication.

pubs: The keyword that requests information about all publications that the specified primary article belongs to.

pri_art: The name of a primary article. Primary article names can be specified in the form owner.name.

To avoid problems on case-insensitive data servers, always specify primary object names using the same character case as returned by the catalog stored procedures on the primary data server.

conn=conn_name

The label identifying a primary database connection. The connection name (conn_name) must be specified in the form ds.db, where:

sp_helpprimaryart

Returns information about all primary articles in all primary database connections.

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

sp_helpprimaryart info, "joe.table1", "conn=boulder.doc"

Returns information about the primary article table1 with owner joe in the primary database doc on the data server boulder.

sp_helpprimaryart fields, "joe.table1", "conn=boulder.doc"

Returns field information about the primary article table1 with owner joe in the primary database doc on the data server boulder.

sp_helpprimaryart pubs, "joe.table1", "conn=boulder.doc"

Returns all publications that own the primary article table1 with owner joe in the primary database doc on the data server boulder.

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

**Table 4-11: ASE Replicator primary article 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.
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 listing information about primary article fields, the following result set is returned:

**Table 4-12: ASE Replicator primary article field information**
Column	Datatype	Description
ds	sysname	Name of the local primary data server.
db	sysname	Name of the local primary database.
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 primary object: table procedure
field_id	smallint	Field identifier, ordinal position.
field_name	sysname	Name of the published field (column or parameter name).
datatype	sysname	Datatype of the field.
precision	int	Length of string or binary field, or precision of a numeric field, if applicable. Otherwise, 0.
scale	smallint	Scale of numeric field, if applicable. Otherwise, 0.

When sp_helpprimaryart is invoked with no keyword, it returns information about all primary articles in all primary database connections.
When you invoke sp_helpprimaryart with the fields keyword and an article name (pri_art), you must specify either a connection name (conn=conn_name) or a publication name (pub=pub_name).

To avoid problems on case-insensitive data servers, always specify primary object names using the same character case as returned by the catalog stored procedures on the primary data server.
To get information about replicate articles, use sp_helpreplicateart.
To get information about publications or subscriptions, use sp_helppub or sp_helpsub.
To get information about database connections, use sp_helpconn, sp_helpprimaryconn, or sp_helpreplicateconn.
When an error occurs, an error message is returned.