weird issue in ODBC

pxraja · Post by **pxraja** » Wed Oct 08, 2008 12:22 am

Hi all,

While I am trying to run the job in production I can see this message and the job got aborted without any rows transformed.

DSD.BCIOpenW call to SQLPrepare failed.
SQLSTATE=S1C00, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not implemented.|

I am using custom query that is working fine with development environment.

but do know why its aborted in production?

any ideas and suggestions are welcomed

thanks in advance

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2008 12:44 am

Of course not.

Unless you give us some clue about what "optional feature" you are relying on by posting your custom SQL we are totally in the dark.

Maybe you can use ODBC tracing to determine which SQL function caused the error to be generated.

chulett · Post by **chulett** » Wed Oct 08, 2008 7:11 am

Also check for differences in the ODBC setups done in each environment.