Lesson 4: Creating a SQL Remote message type

Define the message type to use when sending the data/messages. All messages that are sent as part of a replication use a message type. 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.

 Create the message type (Interactive SQL)

  1. 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"

  2. Execute the following statement to create a FILE message type:

    CREATE REMOTE MESSAGE
TYPE file
ADDRESS 'hq';
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1