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) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (E-O)

 

ML_GET_SERVER_NOTIFICATION [System]

This function allows Ultralite users to use light weight polling to query a notifier on a MobiLink server for server-initiated sync requests.

Syntax
ML_GET_SERVER_NOTIFICATION(notifier, address, key)
Parameters
  • Notifier   The name of the notifier on the MobiLink server to poll.

  • Address   The stream parameters, specified as:
    tcpip{host=pc1;port=1234}

    for example.

  • Key   Optional. The notification request key.

Returns

Returns the subject and content of a notification request for the given request key.

Remarks

If there are no requests for the given request key, or if the notifier name does not exist on the MobiLink server, the result is NULL. If NULL is provided for the request key, then the remote ID of the user is used as the request key. If a request does exist, the resulting message is returned in the form: [subject]content (for example, [sync]profile1).

This function communicates over the network as it retrieves responses from the MobiLink server. As a result, this function may require a long execution time resulting from network latency. During execution, there may be periods when the function can execute in the background, allowing work to be performed in the runtime on other connections. These periods are not guaranteed however, and depend on the complexity of the SQL. The recommended method for users to retrieve a MobiLink address to use in this function is to use the sync_profile_option_value function with an existing synchronization profile to get the value for the Stream profile option. The value returned by this function call can be used directly as the MobiLink address parameter.

See also
Standards and compatibility
Example
Select ml_get_server_notification('Notifier1', 'tcpip{host=sybase;port=1234}', 'MyKey'