❖Tocreate an article using a subscription expression (Sybase Cen-
tral)
1. Connect to the database as a user with DBA authority.
2. In the left pane, select the Publications folder.
3. From the File menu, choose New ➤Publication.
ThePublication Creation wizard appears.
4. Type a name for the publication and click Next.
5. On the Tables tab, configure the desired values for that table.
6. On the SUBSCRIBE BY Restrictions tab, use the controls to create the
subscriptionexpression.
7. Follow the remaining instructions in the wizard.
❖Tocreate an article using a subscription expression (SQL)
1. Connect to the database as a user with DBA authority.
2. Execute a CREATE PUBLICATION statement that includes the
expressionyou wish to use as a match in the subscription expression.
Examples ♦Thefollowing statement creates a publication that publishes the id,
company_name,city, and state columns of the customer table, and which
matchesthe rows with subscribers according to the value of the state
column:
CREATE PUBLICATION pub_customer (
TABLE customer (
id,
company_name,
city,
state )
SUBSCRIBE BY state
)
♦Thefollowing statements subscribe two employees to the publication:
AnnTaylor receives the customers in Georgia (GA), and Sam Singer
receivesthe customers in Massachusetts (MA).
CREATE SUBSCRIPTION
TO pub_customer (’GA’)
FOR Ann_Taylor ;
CREATE SUBSCRIPTION
TO pub_customer (’MA’)
FOR Sam_Singer
98