Columns' descriptions are not imported when using InfoSphere DataStage ODBC Table Import
Importing table definitions from Microsoft SQL Server ® or Oracle ® databases using ODBC is not retrieving the columns' descriptions defined in table's data definition language (DDL). DataStage Designer includes a Description column for tables that suggets this information could be populated from the database but the importing is not populating this column attribute.
This is a limitation of the ODBC drivers. This standard does not support importing descriptions or user comments for any database object.
Resolving the problem
It is not possible to import this information into DataStage by using ODBC drivers since they do not implement this functionality. For Oracle databases, the columns' description can be imported by using the Oracle Connector Stage, which uses a different set of libraries than the ODBC drivers. For other databases this information can be added manually.
More support for:
InfoSphere Information Server
Software version: 8.0.1, 8.1, 8.5, 8.7, 9.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1643552
Modified date: 29 July 2013