DSXchange

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

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.

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