Sybase DC38133-01-0902-01 manual Sample publication, To add the publication to the sample database

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 pathnscriptsnsalespub.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