Anyone needing to access RDBMSs from C++ should know about OTL - the Oracle, Odbc and DB2-CLI Template Library http://otl.sourceforge.net/home.htm
which is way cool. I've used it in several projects with Oracle 8i and MS SQLServer 7. Its easy and fast. It rocks. And it drives SAP DB as well. I've attached tweaked versions of C++ examples showing how to call stored procedures. Also SPs which return result sets (cursors). What's left to show is how to do 1. BULK INSERT/UPDATE/DELETE 2. Using Cursors as IN parameters in SPs (is this possible at all? something like Oracle ref_cursors) 3. BLOBs/CLOBs? 4. Streams and internal ABAP-Tables as SP-Parameters (LiveCache) Greets, Tobias Example 21 (Simple Insert/Select) Works without any modification with SAP DB. Example 24 (SAP DB stored procedure call) see attached DbClient2.cpp Example 25 (Implicit Select/Result Set returned by a stored procedure) see attached DbClient3.cpp
DbClient2.cpp
Description: Binary data
DbClient3.cpp
Description: Binary data
