CLI without ODBC

[steingold]

Hi all,
I'm developing a C++ application that needs to communicate with DB2. It
seems that the only way to do that, according to the IBM documentation,
is with the CLI API.

The problem with this API is that it needs an ODBC datasource to be
configured, and I want to avoid this because it makes the installation
of my product to be more complicated, and I cannot switch between
databases within the same instance the way that the CLP enable.

1) Is there another API to communicate with database in C++ beside CLI
?
2) Is there a way to work with CLI without configuring datasource ( I
know that the CLP does not require configuration of datasource) ?
3) Is it possible to switch between databases in the same instance
using CLI without configuring multiple datasources?
TIA,
Yaron

[Knut Stolze]

st*******@gmail.com wrote:

Hi all,
I'm developing a C++ application that needs to communicate with DB2. It
seems that the only way to do that, according to the IBM documentation,
is with the CLI API.
Then you have missed completely the description of embedded SQL.
The problem with this API is that it needs an ODBC datasource to be
configured,
No, it doesn't. You do need a DB2 client installed, though.
and I want to avoid this because it makes the installation
of my product to be more complicated, and I cannot switch between
databases within the same instance the way that the CLP enable.

CLI allows you to do that. In fact, a CLI app can be connected to several
databases at the same time.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany