DSXchange

In transformer stage/ in ODBC Stage there are few columns like,
1. column name
2. key
3. SQL type
4. Extended
5. Length
6. Scale
7. Nullable
8. Description

In the Description column I found some extra information i.e. "<none>
Searchable? N "

can anybody tell me what is the purpose of this desciption? When it is used by DataStage?

Hey, i think the description field just helps you out to distinguish between columns that you define, and it will have no impact on functionality.

"<none>" indicates that there is no description for the field, whether imported from the database or added manually during the import process or subsequently.
"searchable" indicates whether or not the column in the database is indexed. This is determined at the time that the table definition is imported; it is not automatically maintained if the column is indexed subsequent to that import.