Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » QAnywhere » QAnywhere API Reference » QAnywhere SQL API reference » Message properties, headers, and content » Message content



Returns the message content of a text message.

Item Description Remarks
1 Message ID VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage.
Return value

The text content as LONG VARCHAR.

If the message has binary content rather than text content, this stored procedure returns null.


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

See also

In the following example, the content of a message is output to the database server messages window:

    declare @msgid varchar(128);
    declare @content long binary;
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @content = ml_qa_gettextcontent( @msgid );
    message 'message content: ' || @content ;