Sybase Workspace provides several functions that enable you to retrieve and view information about properties for an XML message. To parse XML message properties in Sybase WorkSpace with these functions, use the following procedure.
From Database Explorer under your ASE connection profile, expand the Procedures and Functions folder or, for triggers, expand the Tables folder and expand the table, then the Triggers folder.
Select the procedure for which you want to parse XML message properties. Right-click and select Edit Procedure. Alternatively, select the trigger for which you want to parse XML message properties. Right-click and select Edit Trigger.
The procedure or trigger code appears in SQL Editor.
Place the cursor in the desired location in the code, right-click and select Adaptive Server Enterprise | Real-time Messaging Wizard. You can also open the Real-time Messaging Wizard from the
icon on the toolbar. The Select a Wizard dialog appears. Select the appropriate
Property related function:Get property list – Select this wizard to retrieve the list of properties belonging to a message.
See Retrieving an XML Message Property List to continue.
Get property count – Select this wizard to retrieve the number of properties belonging to a message.
See Retrieving an XML Message Property Count to continue.
Get property name – Select this wizard to retrieve the name of a message property.
See Retrieving an XML Message Property Name to continue.
Get property value – Select this wizard to retrieve the value of a message property.
See Retrieving an XML Message Property Value to continue.
Get property type – Select this wizard to retrieve the type of a message property.
See Retrieving an XML Message Property Type to continue.