|
Returns the QAnywhere address of the message.
|
Item |
Description |
Remarks |
|---|---|---|
|
1 |
Message ID |
VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage. |
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.
In the following example, a message is received and its address is output to the database console:
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