Returns the message type (text or binary).
Item | Description | Remarks |
---|---|---|
1 | Message ID | VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage. |
The content class as INTEGER.
The return value can be:
1 indicates that the message content is binary and should be read using the stored procedure ml_qa_getbinarycontent.
2 indicates that the message content is text and should be read using the stored procedure ml_qa_gettextcontent.
You can read this content 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 the content is output to the database server messages window:
begin declare @msgid varchar(128); declare @contentclass integer; set @msgid = ml_qa_getmessage( 'myaddress' ); set @contentclass = ml_qa_getcontentclass( @msgid ); if @contentclass = 1 then message 'message binary is ' || ml_qa_getbinarycontent( @msgid ); elseif @contentclass = 2 then message 'message text is ' || ml_qa_gettextcontent( @msgid ); end if; commit; end |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |