Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 (Français) » MobiLink - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Server-initiated synchronization using gateways

 

Lesson 3: Structure a push request

The Notifier sends a message to a device when it detects a push request.

♦  To create a simple table for storing push requests

  1. Execute the following command 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;

  2. Close Interactive SQL.

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1