HCL OneDB Client Software Development Kit components

You use the Client SDK to develop and run client applications. Client SDK includes APIs, programs, and database utilities.

Applications that run on client computers require HCL® OneDB® Connect to access database servers. OneDB Connect is a runtime connectivity product that is composed of runtime libraries that are included in Client SDK.

The following table describes the APIs and programs of Client SDK.

Table 1. Client SDK APIs and programs
Component Description
HCL OneDB .NET Core Provider (Windows™ only) The HCL OneDB .NET Core Provider is a .NET assembly that lets .NET applications access and manipulate data in HCL OneDB databases. It does this by implementing several interfaces in the Microsoft™ .NET Framework that are used to access data from a database. Using the HCL OneDB .NET Core Provider is more efficient than accessing the HCL OneDB database through either of these methods:
  • Using the Microsoft .NET Framework Data Provider for ODBC along with the HCL OneDB ODBC Driver
  • Using the Microsoft .NET Framework Data Provider for OLE DB along with the HCL OneDB ODBC Driver

For more information, see the HCL OneDB .NET Provider Guide.

HCL OneDB ESQL/C with XA support An SQL embedded-language product that is used to create custom C applications.

For more information, see the ESQL/C Guide.

HCL OneDB Object Interface for C++ A C++ interface to develop object-oriented client applications for use with all HCL OneDB database servers and client-side value objects for HCL OneDB

For more information, see the OneDB Object Interface for C++ Guide.

HCL OneDB GLS (Global Language Support) An interface that allows HCL OneDB products to use different locales that have defined conventions for a particular language, culture, or code set.

For more information, see the ESQL/C Guide and the GLS User's Guide.

HCL OneDB ODBC Driver with MTS support The HCL OneDB implementation of the Open Database Connectivity (ODBC) 3.0 Level 1+ standard that supports Microsoft Transaction Server (MTS). This driver contains extensibility support for HCL OneDB.

For more information, see the HCL OneDB ODBC Driver Guide.

HCL OneDB OLE DB Provider (Windows only) A client-side, native OLE DB provider that implements full functionality for base-level providers and contains extensibility support for HCL OneDB.

For more information, see the HCL OneDB OLE DB Provider Guide.

The provides libraries and utilities for SSL communication.

For more information, see the ../com.ibm.sec.doc/ids_ssl_006.html#ids_ssl_006.

HCL Data Server Driver Package The HCL Data Server Driver Package includes drivers that are compatible with Distributed Relational Database Architecture™ (DRDA®) protocols. For a list of the contents of the HCL Data Server Driver Package, see data server client and driver types.

You can use the .NET Core Provider JDBC Driver to develop JDBC applications with HCL OneDB software.

You can use the .NET Core Provider .NET Provider to develop .NET applications with HCL OneDB software. The .NET Core Provider .NET Provider includes support for web application development in .

HCL Data Server Driver Package installation does not affect an existing installation of the HCL OneDB .NET Core Provider or the OneDB JDBC Driver. You can use either or both of the .NET Providers or JDBC drivers.

For more information about the differences between the Data Server .NET Provider and the OneDB .NET Core Provider, see NEED

The following table describes the HCL OneDB common database utilities in the Client SDK.

Table 2. HCL OneDB common database utilities
Component Description
Documentation Viewer Use the viewer to see the release and machine notes in text format.
The finderr utility on UNIX™ systems and the HCL OneDB Error Messages utility on Windows systems Use these utilities to obtain information about error messages, including corrective actions, that are specific to HCL OneDB.
The ILogin utility (Windows only) Use the ILogin Demo utility to quickly test the connection to HCL OneDB. Click File > Run then enter the HCL OneDB connection parameters. You must create the target database before you connect to it.
Password CSM HCL OneDB Password Communications Support Module for client applications. Password CSM must also be installed on the HCL OneDB database server to which the client connects.

For more information, see CSM configuration file.

Connection Manager The Connection Manager is a utility that can monitor the workload and status of database servers in high-availability clusters, Enterprise Replication domains, grids, and server sets.

Connection Managers can control failover for high-availability clusters, direct client connection requests to appropriate database servers, act as proxy servers to handle client/server communication, and prioritize connections between application servers and the primary server of a high-availability cluster.

For more information, see Connection management through the Connection Manager.

DB-Access The DB-Access utility is included in the HCL OneDB Client SDK when the corresponding HCL OneDB server version is available for the same operating system. When the DB-Access utility is included in the Client SDK, it is the same utility that is delivered with the HCL OneDB server. The utility provides a stand-alone client command-line tool that can directly access the HCL OneDB database instance. This dbaccess client supports the same user interface and functionality as the dbaccess server utility.

For the setup requirements, see Requirements for the HCL OneDB Client Software Development Kit DB-Access utility.

The ConnectTest utility (Windows only) Use the ConnectTest utility to test the connection to the HCL OneDB server. You can start the utility from the shortcut in the Start menu or from the $INFORMIX/bin directory. The utility populates the server details from the registry that is registered by the Setnet32 utility. You can manually edit the utility to connect to other servers not listed in the registry, which does not modify the registry entry. The utility shows the resulting data of the executed SQL query.
Setnet32 (Windows only) Use the Setnet32 utility for configuring client products. Each package might include online help, example programs, and support programs.
Note: Beginning with Client SDK Version 3.50.xC6, is no longer installed with Client SDK or OneDB Connect. is available for download at: https://www14.software.HCL.com/webapp/iwm/web/preLogin.do?source=swg-daivs.

The latest version of supports only the Data Server .NET Provider and does not support Client SDK OneDB .NET Core Provider. Information about using the add-ins with the Client SDK OneDB .NET Core Provider is available at: http://www-933.HCL.com/support/fixcentral/.