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

Execute a parameterized procedure

To execute a parameterized user-defined procedure, you can use the EXECUTE...USING SQL DESCRIPTOR statement to provide the argument values from a system-descriptor area and to execute the procedure. You handle the input parameters of a user-defined procedure in the same way 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 SQL DESCRIPTOR statement for the user-defined procedure.