This stored procedure opens a result set over the property names of the specified message. The message ID parameter must be
that of a message that has been received.
The result set is a single VARCHAR(128) column, where each row contains the name of a message property. QAnywhere reserved
property names (those with the prefix "ias_" or "QA") are not returned.
You can read this property after a message is received and until a rollback or commit occurs; after that you cannot read it.
The following example declares a cursor over the result set of property names for a message that has the message ID msgid.
It then gets a message that has the address clientid\queuename; opens a cursor to access the property names of the message;
and finally fetches the next property name.
begin
declare prop_name_cursor cursor for
call ml_qa_getpropertynames( @msgid );
declare @msgid varchar(128);
declare @name varchar(128);
set @msgid = ml_qa_getmessage( 'clientid\queuename' );
open prop_name_cursor;
lp: loop
fetch next prop_name_cursor into name;
if sqlcode <> 0 then leave lp end if;
...
end loop;
close prop_name_cursor;
end
Parameters