SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Creating publications

Creating articles containing some of the rows in a table

There are two ways of including only some of the rows from a table in an article:

• WHERE clause    You can use a WHERE clause to include a subset of rows in an article. All subscribers to the publication containing this article receive the rows that satisfy the WHERE clause.

• subscription column    You can use a subscription column to include a different set of rows in different subscriptions to publications containing the article.

Allowed clauses 

In SQL Remote for Adaptive Server Enterprise, the following limitations apply to each of these cases:

• WHERE clause limitations    The only form of WHERE clause supported is the following:

  WHERE column-name IS NOT NULL.

• Subscription column    SQL Remote for Adaptive Server Anywhere supports expressions other than column names. For Adaptive Server Enterprise, the subscription expression must be a column name.

When to use WHERE and SUBSCRIBE BY 

You should use a subscription expression when different subscribers to a publication are to receive different rows from a table. The subscription expression is the most powerful method of partitioning tables.

Creating an article using a WHERE clause
Creating an article using a subscription column