ODBC Stored Procedures

[Crisps]

I would like to call a stored procedure VIA ODBC. The underlying ODBC connection may point to any database, but probably one of DB2, ORACLE, MSSQL or MYSQL.

Is there a means possible in C++ code to make a single call of the stored proc which will work for all of them. I have found so far you need to specify different statements for different products.

SQL

rc = SQLPrepare(hStatement, (SQLCHAR*)"EXEC TOPSCORE (?, ?)", SQL_NTS);

DB2

rc = SQLPrepare(hStatement, (SQLCHAR*)"CALL NULLID.TOPSCORE (?, ?);", SQL_NTS);

Thanks,

 

[SQLBill]

Since you are looking for a C++ statement, I suggest you post in a C++ forum on this site. Use the Find A Forum search.

-SQLBill

Posting advice: FAQ481-4875