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.
Dynamic SQL
Determine SQL statementsIf you do not know until run time what SQL statement to execute, you can dynamically determine that statement with the DESCRIBE statement and use a dynamic-management structure to hold any values that the statement sends to or receives from the database server.
Determine statement information at run time
Handling statements that contain user-defined data types
SQL statements with opaque-type columns

SQL statements with opaque-type columns

For dynamic execution of opaque-type columns, keep in mind the following items:

You must ensure that the type and length fields of the dynamic-management structure (system-descriptor area or sqlda structure) match the data type of the data you insert into an opaque-type column.
truncates opaque-type data at 32 kilobytes if the host variable is not large enough to hold the data.