Sets the specified message property from a SQL SMALLINT data type.
Item | Description | Remarks |
---|---|---|
1 | Message ID | VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage. |
2 | Property name | VARCHAR(128) |
3 | Property value | SMALLINT |
You cannot alter this property after the message has been sent.
In the following example, a message is created, the short properties myshortproperty1 and myshortproperty2 are set, and the message is sent to the address clientid\queuename:
begin declare @msgid varchar(128); set @msgid = ml_qa_createmessage(); call ml_qa_setshortproperty( @msgid, 'myshortproperty1', -12345 ); call ml_qa_setshortproperty( @msgid, 'myshortproperty2', 12345 ); call ml_qa_putmessage( @msgid, 'clientid\queuename' ); commit; end |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |