SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Creating publications
      Creating articles containing some of the rows in a table

Creating an article using a subscription column

The subscription column is used when rows are to be shared among many remote databases.

To create an article using a subscription column

1. If you have not already done so, mark the table for replication. You do this by executing the sp_add_remote_table procedure:

   sp_add_remote_table table_name

2. Add the table to the publication. You do this by executing the sp_add_article procedure: Specify the column name you wish to use as a subscription expression in the fourth argument to the procedure:

   sp_add_article publication_name,
       table_name, 
       NULL,
      column_name

   You must include the NULL entry to avoid adding a WHERE clause.

3. If you wish to include only a subset of the columns in the table, specify the columns using the sp_add_article_col procedure. You must include the column specified in your subscription expression in the article.

Example 

• The following set of statements create a publication containing a single article, which supports subscriptions based on the value of column col_1:

  sp_create_publication test_pub
  sp_add_remote_table test_table
  sp_add_article test_pub,
     test_table,
     NULL,
     col_1
  go