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.
I just looked in TD v5.2 Help for SqlPrepareSP shipped with TD and see this sentence in the description: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.
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.TD supports output parameters only with Oracle OLE DB provider.
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.
Thanks for answering my question.
I might have to think about a workaround
Who is online
Users browsing this forum: [Ccbot] and 5 guests