Normally, message synchronization is handled by the QAnywhere Agent. However, if the synchronization policy is on demand, then it is the application's responsibility to trigger the synchronization of messages. You can do so using this stored procedure. The trigger does not take effect until the current transaction is committed.

• Setting up SQL applications

In the following example, a message is sent and the transmission of the message is immediately initiated:

begin
    declare @msgid varchar(128);
    set @msgid = ml_qa_createmessage();
    call ml_qa_settextcontent( @msgid, 'my simple message' );
    call ml_qa_putmessage( @msgid, 'clientid\queuename' );
    call ml_qa_triggersendreceive();
    commit;
end