User guide

Data Integration with Sybase Avaki Studio 141
Input Source
When you’re done, click Next to continue to the “Column Definitions” page.
• Click the Add button to add a column.
• To delete one or more columns, select them and click Delete.
• To reorder the columns, select one or more of them and click the Move Up or
Move Down buttons. (If you want to move multiple columns, the selection must be
contiguous.)
• You can edit the properties of each column:
 Name: Click in the Name field and edit the column’s name. If you use the
Browse XPath… button to choose the XML node for a given column, Studio
will automatically set the column’s name to the name of that node (unless
you’ve already edited the name).
 Type: Specify the type of the column’s data. When you create a new column, Stu-
dio defaults its type to VARCHAR since XML data is by nature text-based. If you
change this, make sure that the data in the document can be parsed as the type