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
weird issue in ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.