Parsing an XML Document with xmlparse

To parse an XML document with xmlparse from Sybase WorkSpace, use the Parse XML to image wizard as follows:

Invoke the Parse XML to image 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.
XML error handling	Select an error-handling option from the menu dropdown. The options are exception, null, and message. The default is exception.

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.

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 xmlparse command with your specified options is displayed in the Preview field.

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