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.
The client-server connectionThe application can establish a connection to any valid database environment. A database environment can be a database, a database server, or a database and a database server.
Connect to a database server
Establish a connection
Summary of connection types

Summary of connection types

The following table summarizes the methods that supports to connect to a database server.

Table 1. Statements and functions that start the database server
The first column is the SQL statement or ESQL/C function. The second top column has two columns underneath it for the different types of connections: Implicit and Explicit. The third top column shows Effect on a connection to the database server and underneath it two columns: Establishes a connection and Opens a database.
SQL statement or ESQL/C function	Implicit	Explicit	Establishes a connection	Opens a database
If first SQL statement in the program is:
DATABASE	Y		Y	Y
CREATE DATABASE	Y		Y	Y
START DATABASE	Y		Y	Y
DROP DATABASE	Y		Y
sqlstart()	Y		Y
CONNECT TO DEFAULT		Y	Y
CONNECT TO '@`servername`'		Y	Y
CONNECT TO '`dbname`'		Y	Y	Y
CONNECT TO '`dbname`@`servername`'		Y	Y	Y

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.