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.
What is HCL OneDB™ ESQL/C?
Opaque data typesThese topics explain how to use the lvarchar, fixed binary, and var binary data types to access an opaque data type from the program. Use these data types to represent an opaque data type as it is transferred to and from HCL OneDB™.
Access the internal format of an opaque type
Access a varying-length opaque type

Access a varying-length opaque type

The var binary data type allows you to access the internal format of either of the following opaque data types:

A fixed-length opaque-type column for which you do not have access to the C-structure of the internal format
A varying-length opaque-type column

Follow these steps to transfer the internal format of either of these opaque data type columns between the database server and the application:

Declare a var binary host variable
Use the var binary host variable in an SQL statement to perform any select, insert, update, or delete operations on the internal format of the opaque-type column.