Retrieving an XML Message Property Value

To retrieve a property value for an XML message from Sybase WorkSpace, use the Get property value wizard as follows:

Invoke the Get property value wizard (see Retrieving XML Message Properties for instructions).

Modify the following fields.

Properties query options

Field	Example
XML message document	Choose one of the following Message header – Retrieve the message header. Message properties – Retrieve the message properties. This is the default.
Property name	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".

Field

Example

XML message document

Choose one of the following

Property name

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".

The SQL for retrieving the message property value is displayed in the Preview field.

Click Finish. The SQL for retrieving the message property value appears in SQL Editor.