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
Determine SQL statementsIf you do not know until run time what SQL statement to execute, you can dynamically determine that statement with the DESCRIBE statement and use a dynamic-management structure to hold any values that the statement sends to or receives from the database server.
Determine statement information at run time

Determine statement information at run time

Consider a dynamic-management structure when you execute an SQL statement under the following conditions:

Something is not known about the structure of an SQL statement:
- The type of statement to execute is unknown.
- The table name is unknown and therefore the columns to be accessed are unknown.
- The WHERE clause is missing.
Something is not known about the number or type of values that passes between the program and the database server:
- The number and data types of columns in the select list of a SELECT or in a column list of an INSERT
- The number and data types of input parameters in the statement are unknown
- The number and data types of return values of a user-defined function (executed with the EXECUTE FUNCTION statement) are unknown