Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » QAnywhere » QAnywhere SQL API Reference » Message properties, headers, and content » Message properties

ml_qa_getlongproperty Next Page


Retrieves the property names of the specified message.






Message ID

VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage.


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.

See also

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.

 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;