Calling SP in SQLWin 5.0.2 & TD2000 DB2/Win with ODBC

[FeelFell]

Hi all,

I am new to the forum. Currently I got a problem when I am trying to migration my database from Oracle 8.1.7 to DB2/Windows. In my code, I used "SqlPLSQLCommand" to call stored procedure (SP) with in/out parameters. However, when I switched to use ODBC driver to connect to DB2, I could not make use of the function call again as it told me that it's not an Oracle DB.

Is there any other way that I could call SP on ODBC?
Should I migrate my code to TD5.1/TD5.2 in order to call SP as I found from the maunal, there's a "SqlPrepareSP" function using OLE DB.

Thanks in advance for help.

[Jeff Luther]

I have not used SqlPrepareSP(), but to respond to your question:

Should I migrate my code to TD5.1/TD5.2 in order to call SP as I found from the maunal, there's a "SqlPrepareSP" function using OLE DB.

I just looked in TD v5.2 Help for SqlPrepareSP shipped with TD and see this sentence in the description:

TD supports output parameters only with Oracle OLE DB provider.

So, it doesn't look like a migration is going to help you be able to call this function with DB2/Windows and I don't know of a workaround for you.

P.S. I just noticed your msg. title is "SQLWin 5.0.2" -- I misread that as (TD) 5.2, the latest version of TD. Sounds like you are using the 16-bit version of SQLWindows from the 1990's, though what I wrote above would still likely be true.

[FeelFell]

Jeff,

Thanks for answering my question.
I might have to think about a workaround