Columns' descriptions are not imported when using InfoSphere DataStage ODBC Table Import

Technote (troubleshooting)


Problem(Abstract)

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.

Cause

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.

Product Alias/Synonym

DataStage

Rate this page:

(0 users)Average rating

Document information


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:

2013-07-29

Translate my page

Machine Translation

Content navigation