Returns the QAnywhere address of the message.

Parameters

Return value

The QAnywhere message address as VARCHAR(128). QAnywhere message addresses take the form id\queue-name.

You can read this header after a message is received and until a rollback or commit occurs; after that you cannot read it.

See also

• Setting up SQL applications
• QAnywhere message addresses
• ml_qa_createmessage
• ml_qa_getmessage

Example

In the following example, a message is received and its address is output to the database server messages window:

begin
    declare @msgid varchar(128);
    declare @addr varchar(128);
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @addr = ml_qa_getaddress( @msgid );
    message 'message to address ' || @addr || ' received';
    commit;
end