Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Statement Reference

UltraLite CREATE INDEX statement Next Page

UltraLite CREATE PUBLICATION statement


Creates a publication.

Syntax

CREATE PUBLICATION publication-name
(TABLE table-name [ WHERE search-condition ], ... )

Parameters

WHERE clause    If a WHERE clause is specified, only rows satisfying search-condition are considered for upload from the associated table during synchronization. See Search conditions in UltraLite.

If you do not specify a WHERE clause, every row in the table that has changed in UltraLite since the last synchronization is considered for upload.

Remarks

A publication establishes tables that are synchronized during a single synchronization operation. They determine which data is uploaded to the MobiLink server. The MobiLink server may send back rows for these (and only these) tables during its download session. Rows that are downloaded do not have to satisfy the WHERE clause for a table.

Only entire tables can be published. You cannot publish specific columns of a table in UltraLite.

Side effects
See also
Example

The following statement publishes all the columns and rows of two tables.

CREATE PUBLICATION pub_contact (
   TABLE contact,
   TABLE company
)

The following statement publishes only the active customer rows by including a WHERE clause that tests the status column of the customer table.

CREATE PUBLICATION pub_customer (
   TABLE customer 
   WHERE status = 'active'
)