Imported Table Definition not in ODBC Connector Repository

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Imported Table Definition not in ODBC Connector Repository

Post by sjordery »

Hi All,

We have imported an ODBC table definition, and when viewed from the Designer repository window, it appears fine. However, when we use query builder in the ODBC Connector stage, the table definition does not appear in the repository at the side of that stage.

Any ideas?

Thanks,
S
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

OK, having had a good look around, it seems that it was imported into a different sub-folder. The table name is something like:

SubName1.TableOne

In the subcategories we also have SubName2. When imported, the table-definition was saved as:

SubName2.TableOne

Very strange, but at least we found it.
Post Reply