Retrieving XML Message Properties

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

1. From Enterprise Explorer, find the ASE connection profile.
2. Select the procedural object for which you want to parse an XML message properties.

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

3. Place the cursor in the desired location in the code, right-click and select Adaptive Server Enterprise > Real-time Messaging Wizard.
4. Select the appropriate XML message property you wish to retrieve.

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

5. 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 – retrieve the message properties. This is the default.
   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.

6. Click Finish.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.