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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Dynamic SQL
An sqlda structureAn sqlda structure is a dynamic-management structure that can hold data that is either returned from or sent to the database server by a prepared statement. It is a C structure defined in the sqlda.h header file.
Handling a parameterized user-defined routine

Handling a parameterized user-defined routine

For an introduction on how to determine input parameters, see Determine unknown input parameters. This section describes how to handle a parameterized user-defined routine with an sqlda structure. The following statements execute user-defined routines:

The EXECUTE FUNCTION statement executes a user-defined function (external and SPL).
The EXECUTE PROCEDURE statement executes a user-defined procedure (external and SPL).

If a prepared EXECUTE PROCEDURE or EXECUTE FUNCTION statement has arguments specified as input parameters of unknown number and data type, your HCL OneDB™ ESQL/C program can use an sqlda structure to define the input parameters.