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

Troubleshooting

Problem

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":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1;8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

DataStage

Was this topic helpful?

Document Information

Modified date:
16 June 2018

UID

swg21643552

Tips