Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Database server communication
Working with the database serverThese topics explain how the HCL® OneDB® ESQL/C program can interact with a database server.
Interact with the database server
Switch between multiple database connections

Switch between multiple database connections

The application can make a number of simultaneous database connections with a CONNECT statement. These connections can be to several database environments or can be multiple connections to the same database environment. To switch between connections, the application must follow these steps:

Establish a connection with the CONNECT STATEMENT
Handle any active transactions
If the current connection has an active transaction, you can switch connections only if the CONNECT statement with the WITH CONCURRENT TRANSACTION clause establishes the current connection.
Make a connection current with the SET CONNECTION or CONNECT statement