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

General discussion forum about all databases other than SqlBase.
FeelFell

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

Post by FeelFell » 28 Dec 2009, 03:35

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

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

Post by Jeff Luther » 11 Jan 2010, 19:53

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

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

Post by FeelFell » 14 Jan 2010, 08:37

Jeff,

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest