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
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 program can use an sqlda structure to define the input parameters.