Returns the specified message property as 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) |
The property value as SMALLINT.
If the message property value is out of range, then a SQL error with SQLSTATE 22003 occurs.
You can read this property 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 value of the short property myshortproperty is output to the database server messages window:
begin declare @msgid varchar(128); declare @prop smallint; set @msgid = ml_qa_getmessage( 'myaddress' ); set @prop = ml_qa_getshortproperty( @msgid, 'myshortproperty' ); message 'message property myshortproperty is set to ' || @prop; commit; end |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |