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

SQL Anywhere 12.0.1 » MobiLink - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Configuring server-initiated synchronization using gateways


Lesson 3: Creating a table to store push request

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

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.

 Create a simple table for storing push requests
  1. Connect to your database using Interactive SQL.

    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.

  4. Proceed to Lesson 4: Creating a MobiLink project.

 See also