User guide

Operator reference
142 Data Integration with Sybase Avaki Studio
you choose (for example, if the document has the value “foo” and you choose
INTEGER for the type, you will get an error when you execute your data ser-
vice).
 Precision: Specify the precision for the column, if applicable for the column’s
type.
 Scale: Specify the scale for the column, if applicable for the column’s type.
 XPath: Specify an XPath expression that defines the node of the XML document
whose value you want to use for this column. The XPath is relative to the repeat-
ing element you chose on the previous page of the wizard. Studio simplifies the
task of choosing the XPath by providing a browser you can use to choose a node.
This should be sufficient in all but the most complex cases, only requiring a
knowledge of XPath syntax for highly specialized applications. To access the
browser, select the column you’re defining and click Browse XPath… to
choose the node. Make sure you choose the text node (with the icon) if that’s
what you want. In the XPath Browser dialog, Studio shows the values of the first
row’s data next to each node to help you decide what to pick.
When you’re done with this page, click Finish to close the wizard.