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?
HCL OneDB™ ESQL/C programming
Declaring and using host variables
Host variables in data structures
Arrays of host variables supports the declaration of arrays of host variables. You must provide an integer value as the size of the array when you declare the array. An array of host variables can be either one or two dimensional.

Arrays of host variables

supports the declaration of arrays of host variables. You must provide an integer value as the size of the array when you declare the array. An array of host variables can be either one or two dimensional.

You can use elements of an array within statements. For example, if you provide the following declaration:

EXEC SQL BEGIN DECLARE SECTION;
   long customer_nos[10];
EXEC SQL END DECLARE SECTION;

you can use the following syntax:

for (i=0; i<10; i++)
{
   EXEC SQL fetch customer_cursor into :customer_nos[i];
   
⋮

}

You can also use the array name alone within some SQL statements if the array is of type CHAR. For information about specific statements, see the HCL OneDB™ Guide to SQL: Syntax.