The simplest publication you can make consists of a single article, which consists of all rows and columns of a table.
You can use either Sybase Central or Interactive SQL to perform this task.
Sybase CentralIn Sybase Central, you can perform this task while working with the connected database.
To publish one or more whole UltraLite tables (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.
On the Tables tab, select tables from the Available Tables list. Click Add.
Click Finish.
Interactive SQLIn Interactive SQL, you can perform this task with the CREATE PUBLICATION statement.
To publish one or more whole UltraLite tables (Interactive SQL)Connect to the UltraLite database.
Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.
For example, the following statement creates a publication that publishes the whole customer table:
CREATE PUBLICATION pub_customer ( TABLE customer ); |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |