failed to get metadata from RDB oracle ODBC driver

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
actiview
Participant
Posts: 20
Joined: Fri Sep 12, 2008 1:19 pm

failed to get metadata from RDB oracle ODBC driver

Post by actiview »

Hi all,
we have instal the RDB oracle driver(version 3.02).
the test connection is successful.
In the designer I create a job that read a table by the ODBC stage.I defined the rows of the table manualy.
Then the job run and finish successfuly.

My problem is to bring the metadata.
When I try to import the metadata and retrive the tables list I get this message :

DSR.MetaGeta(GET.FOREIGNKEYS)(SQLForeignKeys): BCI Error:
SQLSTATE=S1C00,CODE=0,[DataStage][SQL Client][ODBC][Oracle][ODBC]Driver not capable.

But I get the list of the tables in the screen and when I choose one of the tables and try to import the table I get this message:


DSR.MetaGeta(GET.COLUMNS)(SQLColumns('','','ALICHIM','%')): BCI Error:

Any idea?

Thanks in advance,
Moshe
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The driver you have installed does not support the SQLColumns() function. You need a more capable driver if you wish to import metadata.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply