Returns the in-reply-to ID for the message.

Parameters

Return value

The in-reply-to ID as VARCHAR(128).

Remarks

A client can use the InReplyToID header field to link one message with another. A typical use is to link a response message with its request message.

The in-reply-to ID is the ID of the message that this message is replying to.

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
• ml_qa_setinreplytoid
• ml_qa_createmessage
• ml_qa_getmessage

Example

In the following example, a message is received and the in-reply-to-id of the message is output to the database server messages window:

begin
    declare @msgid varchar(128);
    declare @inreplytoid varchar(128);
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @inreplytoid = ml_qa_getinreplytoid( @msgid );
    message 'message is likely a reply to the message with id ' || @inreplytoid;
    commit;
end