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.
The DESCRIBE statementThe DESCRIBE statement obtains information about database columns or expressions in a prepared statement.
Determine input parametersYou can use the DESCRIBE and DESCRIBE INPUT to return input parameter information for a prepared statement before it is executed.

Determine input parameters

You can use the DESCRIBE and DESCRIBE INPUT to return input parameter information for a prepared statement before it is executed.

The DESCRIBE INPUT statement returns the number, data types, size of the values, and the name of the column or expression that the query returns. The DESCRIBE INPUT statement can return parameter information for the following statements:

INSERT using WHERE clause
UPDATE using WHERE clause
SELECT with IN, BETWEEN, HAVING, and ON clauses.
SELECT subqueries
SELECT INTO TEMP
DELECT
EXECUTE