Parsing an XML Document with xmlextract

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

Invoke the Apply 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.
XML error handling	Select an error-handling option from the menu dropdown. The options are exception, null, and message. The default is exception.
Return type	Enter a return type in the text field, or choose a return type from the menu dropdown.

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

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