Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Remote » Tutorial: Creating a SQL Remote system

 

Lesson 4: Creating a SQL Remote message type

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.

Prerequisites

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.

 Task

  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';

Results

The FILE message type is created.

Next

Lesson 5: Extracting the remote database

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0