User's Manual

Chapter 4. Tutorials for Adaptive Server Anywhere Users
A sample publication
The command file salespub.sql contains a set of statements that creates a
publication on the sample database. This publication illustrates several of
the points of the tutorials, in more detail.
❖ To add the publication to the sample database
1. Connect to the sample database from Interactive SQL.
2. In the SQL Statements pane, execute the following statement:
READ path\scripts\salespub.sql
where path is your SQL Anywhere directory.
The salespub.sql publication adds columns to some of the tables in the
sample database, creates a publication and subscriptions, and also adds
triggers to resolve update conflicts that may occur.
51