A publication can only contain specific table rows. In Sybase Central or Interactive SQL, a WHERE clause limits the rows that are uploaded to those that have changed and satisfy a search condition in the WHERE clause.
To upload all changed rows, do not specify a WHERE clause.
Sybase CentralIn Sybase Central, you can perform this task while working with the connected database.
To publish only some rows in an UltraLite table (Sybase Central)Connect to the UltraLite database.
Right-click the Publications folder, and choose New » Publication.
In the What Do You Want To Name The New Publication field, type a name for the new publication.
Click Next.
In the Available Tables list, select a table and click Add.
Click the WHERE Clauses tab, and select the table from the Articles list. Optionally, you can use the Insert window to assist you in formatting the search condition.
Click Finish.
Interactive SQLIn Interactive SQL, you can perform this task with the CREATE PUBLICATION statement.
To create a publication in UltraLite using a WHERE clause (Interactive SQL)Connect to the UltraLite database.
Execute a CREATE PUBLICATION statement that includes the tables you want to include in the publication and a WHERE condition.
For example, the following example creates a single-article publication that includes all sales order information for sales rep number 856:
CREATE PUBLICATION pub_orders_samuel_singer
( TABLE SalesOrders
WHERE SalesRepresentative = 856 ); |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |