User's Manual

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