Call Level Interface Guide and Reference

Mixing Embedded SQL, Without CONNECT RESET

DB2 CLI's Version 2.1 support of multiple connections may affect existing applications that mix the use of embedded SQL and DB2 CLI.

If your application:

1. Connects to a database using embedded SQL (including using the command line processor or Administrative APIs).
2. (Does NOT issue a reset).
3. Connect to a database using DB2 CLI

the second connect will fail since it is not same type of connection as the first connect.

The application must issue a CONNECT RESET before calling a DB2 CLI connect function.

Note:

An application should always explicitly reset a connection.

[ DB2 List of Books | Search the DB2 Books ]