Transformer Stage extra information column

yogiravi · Post by **yogiravi** » Mon Nov 07, 2011 3:37 am

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?

kogads · Post by **kogads** » Mon Nov 07, 2011 12:27 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 07, 2011 3:05 pm

"<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.