|
Returns the specified message property as a SQL LONG VARCHAR 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 LONG VARCHAR.
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 string property mystringproperty is output to the database console:
begin
declare @msgid varchar(128);
declare @prop long varchar;
set @msgid = ml_qa_getmessage( 'myaddress' );
set @prop = ml_qa_getstringproperty( @msgid, 'mystringproperty' );
message 'message property mystringproperty is set to ' || @prop;
commit;
end