Contents Index Publishing only some rows in a table Publishing only some rows using a subscription expression

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Anywhere
    Publishing data

Publishing only some rows using a WHERE clause


You can specify a WHERE clause to include in the publication only the rows that satisfy the WHERE conditions.

To create a publication using a WHERE clause (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. In the left pane, select the Publications folder.

  3. From the File menu, choose New > Publication.

    The Publication Creation wizard opens.

  4. Type a name for the new publication. Click Next.

  5. On the Tables tab, select a table from the list of Available tables. Click Add. The table is added to the list of Selected Tables on the right.

  6. On the WHERE Clauses tab, select the table then type the search condition in the lower box.

  7. Click Finish.

To create a publication using a WHERE clause (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a CREATE PUBLICATION statement that includes the rows you wish to include in the publication and a WHERE condition.

Examples 

For more information, see the CREATE PUBLICATION statement.

SUBSCRIBE BY 
The create publication statement also allows a SUBSCRIBE BY clause. This clause can also be used to selectively publish rows in SQL Remote. However, it is ignored during MobiLink synchronization.

Contents Index Publishing only some rows in a table Publishing only some rows using a subscription expression