Retrieving XML Message Properties

Sybase WorkSpace provides several functions that enable you to retrieve and view information about properties for an XML message.

For the appropriate ASE connection profile and database, select the appropriate procedural object.

Object	How to select
Stored procedure	Expand the Stored Procedures folder, right-click the stored procedure, and select Edit.
Trigger	Expand the Tables folder, expand the table, and then expand the Triggers folder. Right-click the trigger and select Edit.

In the Source page, place the cursor in the desired location within the SQL code, right-click and select Sybase_ASE_15.x > Real-Time Messaging Wizard .
You can also open the wizard from the ASE Real-Time Messaging Wizard icon on the toolbar.

Select the appropriate XML message property.

XML message property	Description
Get Property List	Retrieve the list of properties belonging to a message.
Get Property Count	Retrieve the number of properties belonging to a message.
Get Property Name	Retrieve the name of a message property.
Get Property Value	Retrieve the value of a message property.
Get Property Type	Retrieve the type of a message property.

Modify the properties query options.

Option	Description
XML Message Document (Count, Value)	Choose one of the following Message Header – retrieve the message header. Message Properties (default) – retrieve the message properties.
Property Name (Value)	Choose one of the following Property Name – specify the property by its name. Variable – specify a variable that stands for the name of the property. Variable names begin with "@". Property Index – specify the property by its index. The default value is 1.
Return Type (List)	Select a return type. Specify a size in bytes for the return type.
Property Index (Name)	Specify the index of the property.