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
Execute a parameterized procedure

Execute a parameterized procedure

To execute a parameterized user-defined procedure, you can use the EXECUTE...USING DESCRIPTOR statement to provide the argument values from an sqlda structure and to execute the procedure. You handle the input parameters of a user-defined procedure in the same way that you handle input parameters in a noncursor function. The only difference between the execution of the EXECUTE PROCEDURE statement and the EXECUTE FUNCTION statement (for a noncursor function) is that you do not need to specify the INTO clause of the EXECUTE...USING DESCRIPTOR statement for the user-defined procedure.