Parsing an XML Document with xmltest

To parse an XML document with xmltest from Sybase WorkSpace, use the Evaluate XML query expression wizard as follows:

Invoke the Evaluate XML query expression wizard. See Parsing an XML Document for instructions.

Modify the following fields.

XML query options

Field	Example
XML Document	Select one of the following: Variable – Enter a variable in the text field, or choose an existing variable from the menu drop-down. Variable names begin with "@". Column name – Enter a table name and column name in the text fields, or click Select Column and choose a table/column pair from the Select Table and Column dialog. XML document – Enter the content of the XML document in the text field, or choose Browse to point to an existing XML document. Embedded expression – Enter an embedded expression in the text field.
XPath expression	Enter an XPath expression in the text field.
Expected value is false	Select this check box to insert "not" into the query between the XPath expression and the XML document expression.
XML error handling	Select an error-handling option from the menu dropdown. The options are exception, null, and message. The default is exception.

The SQL for invoking the xmltest command with your specified options is displayed in the Preview field.

For information on the xmltest command, see XML Services in Adaptive Server Enterprise.