All messages that are sent as part of a replication use a message type. This lesson defines the message type to use when sending the data and messages.
You must have the SYS_REPLICATION_ADMIN_ROLE system role.
Context and remarks
A message type description has two parts:
A message system supported by SQL Remote This tutorial uses the FILE message system. The FILE message system is a simple file-sharing system
A FILE address A user's FILE address is a subdirectory to which all their incoming messages are sent. An application retrieves the messages from this directory. In this tutorial the FILE address of the consolidated database is hq and it is a subdirectory of c:\tutorial.
If you are not currently connected to the consolidated database (hq), run the following command:
dbisql -c "UID=DBA;PWD=sql;SERVER=server_hq;DBF=c:\tutorial\hq.db"
Execute the following statement to create a FILE message type:
CREATE REMOTE MESSAGE TYPE file ADDRESS 'hq';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|