Unable to view data

bobthebuilder · Post by **bobthebuilder** » Tue Sep 20, 2005 9:32 am

All,

I'm able to import metadata into the DS Manager but I'm unable to view the data.

This is the error message I'm getting:

DSBrowser..DSBrowser1.DSLink1: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT X,Y,Z FROM ABC
SQLSTATE=S1C00, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not implemented

Please throw some light on this..

--Bob

Bala R · Post by **Bala R** » Tue Sep 20, 2005 9:43 am

What are the field types of X,Y and Z? Check if your driver supports these datatypes.

bobthebuilder · Post by **bobthebuilder** » Tue Sep 20, 2005 10:06 am

Bala,

I checked the fields and they are the SQL defined types. I also ran the query at my Oracle Client and it works perfect. Do you think it might be a problem in pluging in Oracle with DS.

--Bob

Bala R · Post by **Bala R** » Tue Sep 20, 2005 10:32 am

Don't think its anything with the plugin... Got to do with the ODBC oracle driver you have setup for DS. Lookup the manual for the driver you have installed and whether it supports the datatypes and the length or precision you are trying to select.

kcbland · Post by **kcbland** » Tue Sep 20, 2005 10:46 am

Are you trying to view from DS Manager or from a Designer job? You should try from a Designer job and use the get SQL info button.

bobthebuilder · Post by **bobthebuilder** » Tue Sep 20, 2005 11:08 am

Bala,

Do you mean that I will have to lookup at the Data Direct DSN setup on DS Server for Oracle...

--Bob

bobthebuilder · Post by **bobthebuilder** » Tue Sep 20, 2005 11:10 am

KC,

I have been trying to looup for data at the manager. I tried looking at data at the server and found out that it was asking for a password to connect to the database.

--Bob

bobthebuilder · Post by **bobthebuilder** » Tue Sep 20, 2005 12:22 pm

Thanks Bala

Your analysis was superb....!!!!!!!!!