Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Tutorial: Creating a SQL Remote system


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:

    TYPE file
    ADDRESS 'hq';