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 » MobiLink - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Configuring server-initiated synchronization using gateways


Lesson 3: Creating a table to store push request

In this lesson, you create a push request table for storing push requests. The Notifier sends a message to a device when it detects a push request.


This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up the consolidated database.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Configuring server-initiated synchronization using gateways.

  1. You should be connected to your database in Interactive SQL from the previous lesson.

    If you are not connected to your database, you can start Interactive SQL from Sybase Central or at a command prompt.

    • To start Interactive SQL from Sybase Central, right-click the MLconsolidated - DBA database and click Open Interactive SQL.

    • To start Interactive SQL at a command prompt, run the following command:

      dbisql -c "dsn=sis_cons"
  2. Run the following SQL statements in Interactive SQL:

    CREATE TABLE PushRequest (
        mluser VARCHAR(128),
        subject VARCHAR(128),
        content VARCHAR(128),
        resend_interval VARCHAR(30) DEFAULT '20s',
        time_to_live VARCHAR(30) DEFAULT '1m',
        status VARCHAR(128) DEFAULT 'created'
  3. Close Interactive SQL.


A push request table is created for storing push requests.

 See also