SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Publication property sheet
The Articles tab of the Publication property sheet has the following components:
Tables tab The Tables tab lets you select tables to include in your client database.
Columns tab The Columns tab lets you select columns from the tables to include in your client database.
WHERE Clauses tab The WHERE Clauses tab lets you type a WHERE clause to restrict the rows included in the article.
Articles defined for SQL Remote and MobiLink publications can use a WHERE clause to define a subset of rows of a table to be included in an article. UltraLite applications can use row subsets by supplying a WHERE clause, with one exception: articles in UltraLite publications governing HotSync synchronization cannot use a WHERE clause.
SUBSCRIBE BY Restrictions tab The SUBSCRIBE BY Restrictions lets you type a SUBSCRIBE BY restriction to define a subset of rows to be included in the article. This tab only applies to SQL Remote articles.
Each tab is described in detail below.
Publishing only some rows using a WHERE clause
The Tables tab lets you select tables and add them to the list of articles that are included in the client database.
Available Tables list Lists all the base tables in the database you are currently connected to. To add a table to the Selected Tables list, select the table in the Matching Tables list, then click Add.
You can use the Table Pattern and Owner Pattern fields to limit the tables shown in the Matching Tables list, and so locate the tables you want to include.
Selected Tables list Lists all the tables that are included in the article for the client database. If you want to remove a table from the Selected Tables list, select the table, then click Delete.
Add Adds the table selected in the Matching Tables list to the Selected Tables list so the table is included in the article.
Remove Removes the selected table from the Selected Tables list so the table is not included in the article.
The Columns tab lets you select columns from tables and add them to the list of articles that are included in the client database.
Available columns list Lists the tables selected on the Tables tab. Double-click a table in the list to display its columns. To add a column to the Selected Columns list, select the table in the Available Columns list, then click Add.
Selected columns list Lists all the columns that are included in the article for the client database. If you want to remove a column from the Selected Columns list to remove the column from the article, select the column, then click Delete.
Add Adds the column selected in the Available Columns list to the Selected Columns list so it is included in your client database articles.
Remove Removes the column from the Selected Columns list so it is not included in the article.
Articles defined for SQL Remote and MobiLink publications can use a WHERE clause to define a subset of rows of a table to be included in an article. UltraLite applications can use row subsets by supplying a WHERE clause, with one exception: articles in UltraLite publications governing HotSync synchronization cannot use a WHERE clause.
The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.
Articles list Select a table from the list of tables included in the article.
The selected article has the following WHERE clause In the text box, type the WHERE clause for the table to restrict the rows that are included in the article.
For more information, see Publishing only some rows using a WHERE clause.
The WHERE clause: specifying rows
This tab only applies to SQL Remote articles.
The SUBSCRIBE BY Restrictions tab lets you define a subset of rows of a table for inclusion in the article.
Articles list Select a table from the list of tables included in the article.
The selected article has the following SUBSCRIBE BY restriction You can choose one of the following options for the SUBSCRIBE BY restriction for the article:
None Select this option if the article does not have a SUBSCRIBE BY restriction.
Column Select this option if you wish to include a specific column in the article.
Expression In the text box, type a subscription expression to include a different set of rows in different subscriptions to publications containing the article.
Publishing only some rows using a subscription expression