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.

Prerequisites

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.

 Task
  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 (
        req_id INTEGER DEFAULT AUTOINCREMENT PRIMARY KEY,
        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'
    )
    COMMIT;
  3. Close Interactive SQL.

Results

A push request table is created for storing push requests.

 See also