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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statements

 

UltraLite CREATE PUBLICATION statement

Use this statement to create a publication. A publication identifies synchronized data in an UltraLite remote database.

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

TABLE clause   Use the table to include a TABLE in the publication. There is no limit to the number of TABLE clauses

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, and determines 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; however, 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 Contacts,
   TABLE Customers
);

The following statement publishes only the rows of the Customers table where the State column contains MN.

CREATE PUBLICATION pub_customer (
   TABLE Customers 
   WHERE State = 'MN'
);