ODBC connector is experiencing issue

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
informdaya@gmail.com
Participant
Posts: 37
Joined: Tue Nov 30, 2010 10:51 am

ODBC connector is experiencing issue

Post by informdaya@gmail.com »

Hi All,
i am finding difficulty while reading data from DB2 through ODBC connector stage. When i am using DB2 API stage read the table there is no issue. But same table reading by ODBC connector throwing following error.

"An exception occured while trying to receive the response from handler:ODBC function "SQLNumResultsCols"reported :SQLSTATE=HY000:Native error code =-551:Msg=[IBM(DataDirect OEM)][ODBC Db2 Wire Protocol Driver][UDB Db2 for Windows ,Unix,Linux] Userid do not have privilege to perform operation excute on this object NULLID.DDOU510B"

DBA is saying all privilege is there,as i know other type of stage is working fine on it.

Please assist.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: ODBC connector is experiencing issue

Post by SURA »

Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Post Reply