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.
A fetch arrayA fetch array enables you to increase the number of rows that a single FETCH statement returns from the fetch buffer to an sqlda structure in your program. A fetch array is especially useful when you fetch simple-large-object (TEXT or BYTE) data.

A fetch array

A fetch array enables you to increase the number of rows that a single FETCH statement returns from the fetch buffer to an sqlda structure in your program. A fetch array is especially useful when you fetch simple-large-object (TEXT or BYTE) data.

A fetch of simple-large-object data without a fetch array requires the following two exchanges with the database server:

When fetches a TEXT or BYTE column, the database server returns the descriptor for the column.
then requests the database server to obtain the column data.

When you use a fetch array, sends a series of simple-large-object descriptors to the database server and the database server returns the corresponding column data all at one time.