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.
Dynamic-management structureIf you do not know the number or data types of values sent to or received from the database server, use a dynamic-management structure. A dynamic-management structure allows you to pass a variable-length list of data to the database server, or receive a variable-length list of data from it.
An sqlda structureThe sqlda structure is a C structure (defined in the sqlda.h header file) that holds data returned from a prepared statement.
Fixed-length portion

Fixed-length portion

The following table describes the fixed-size portion of the sqlda structure, which consists of a single field.

Table 1. Field in the fixed-size portion of an sqlda structure
Field	Data type	Description
sqld	short	The number of column values or occurrences in the sqlda structure. This is the number of sqlvar_struct structures, one for each column. The DESCRIBE...INTO statement sets sqld to the number of described columns. You must set sqld to initialize the field before you send column values to the database server.