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
A system-descriptor areaA system-descriptor area is a dynamic-management structure that can hold data that a prepared statement either returns from or sends to the database server. A system-descriptor area conforms to X/Open standards.
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 a system-descriptor area. 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 a system-descriptor area to define the input parameters.