M2M AD301 Podręcznik Użytkownika Pobierz pdf (Strona 151)

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.

1 2 ... 146 147 148 149 150 151 152 153 154 155 156 ... 229 230

Brak uwag

M2M AD301 Podręcznik Użytkownika Strona 151