Use this system procedure to record the MobiLink synchronization state into the ml_sis_sync_state system table.

Parameters

Remarks

Call the ml_set_sis_sync_state system procedure in the publication_nonblocking_download_ack event to allow users to create a request_cursor event that references the ml_sis_sync_state table.

For DB2 mainframe consolidated databases, this procedure is called ml_set_sis_state. See IBM DB2 mainframe server-initiated synchronization system procedure name conversions.

See also

• ml_sis_sync_state
• publication_nonblocking_download_ack connection event

Example

Specify a publication_nonblocking_download_ack event script with the following script to record the synchronization state:

CALL ml_set_sis_sync_state( 
    {ml s.remote_id},
    NULL,
    {ml s.publication_name},
    {ml s.username},
    NULL,
    {ml s.last_publication_download} 
);