ML_GET_SERVER_NOTIFICATION [System]

ML_GET_SERVER_NOTIFICATION(notifier, address, key)

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 the subject and content of a notification request for the given request key.

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.

SYNC_PROFILE_OPTION_VALUE function [System]

SQL/2008 Vendor extension.

SELECT ML_GET_SERVER_NOTIFICATION('Notifier1', 'tcpip{host=sybase;port=1234}', 'MyKey')

ML_GET_SERVER_NOTIFICATION [System]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example