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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, 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
Terminate a connection

Terminate a connection

The HCL OneDB™ ESQL/C program can use the following statements and functions to close a connection:

The CLOSE DATABASE statement closes a database. For applications before version 6.0, it also closes the connection. For applications of Version 6.0 and later, the connection remains open after the CLOSE DATABASE statement executes.
The sqlexit() library function closes all current connections, implicit and explicit. If you call sqlexit() when any databases are still open, the function causes any open transactions to be rolled back.
The sqldetach() library function closes the database server connection of the child process. It does not affect the database server connection of the parent process.
The DISCONNECT statement closes a specified connection. If a database is open, DISCONNECT closes it before it closes the connection. If transactions are open, the DISCONNECT statement fails.