User guide

Data Integration with Sybase Avaki Studio 139
Input Source
Click Next to display the “Column Definitions” page.
If you selected “Use first row of data as column names” on the previous page, the
names of the columns will already be filled in for you. You can edit the properties of
each column. (See “Working with schemas” on page 60 for information about the set-
ting the name, type, precision, and scale of columns.)
 Name: Click in the Name field to edit the column’s name. Even if Studio popu-
lated the names from the first row of the file’s data, you can still edit them here.
 Type: Specify the type of the column’s data. When you create a new column, Stu-
dio defaults its type to VARCHAR since CSV data is by nature text-based. If you
change this, make sure that the data in the document can be parsed as the type
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.