Chapter 18. Command Reference for Adaptive Server Enterprise

 

 

 

sp_add_article procedure

Purpose

To add an article to a publication.

Syntax

sp_add_article publication_name,

 

table_name,

 

 

 

 

where_expr ,

 

 

 

 

subscribe_by_expr ,

 

 

 

 

subscribe_by_view

 

 

 

 

Argument

 

Description

 

 

 

 

 

 

 

 

publication_name

 

The name of the publication to which the article is to

 

 

 

be added.

 

table_name

 

The table containing the article.

 

where_expr

 

This optional argument must be a column name or

 

 

 

NULL. The publication includes only rows for which

 

 

 

the supplied column value is not NULL.

 

 

 

The default value is NULL, in which case no rows are

 

 

 

excluded from the publication.

 

subscribe_by_expr

 

The new subscription expression defining which

 

 

 

rows are to be included in the publication for each

 

 

 

subscription.

 

 

 

The expression must be the name of a column in

 

 

 

table_name. The default value is NULL.

 

subscribe_by_view

 

A view defining the columns and rows to be included

 

 

 

in the publication.

 

 

 

For more information, see “Tuning extraction perfor-

 

 

 

mance” on page 155 and “Tuning extraction perfor-

 

 

 

mance for shared rows” on page 162 .

See also

“sp_add_remote_table procedure” on page 384

 

“sp_create_publication procedure” on page 386

 

“sp_remove_article procedure” on page 428

 

“CREATE PUBLICATION statement” [ASA SQL Reference, page 385]

Description

Running sp_add_article adds an article to a publication. The table must be

 

marked for replication using sp_add_remote_table before it can be added

 

to a publication; failure to do so leads to an error.

Calling sp_add_article adds all the columns of the table to a publication. If

381

Page 399
Image 399
Sybase DC38133-01-0902-01 manual Spaddarticle procedure