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 the data type of a columnThe DESCRIBE statement identifies the data type of a column with an integer value.
X/Open SQL data typesThe X/Open standards support only a subset of the SQL data types that are specific to HCL OneDB™. To conform to the X/Open standards, you must use the X/Open SQL data type constants.

X/Open SQL data types

The X/Open standards support only a subset of the SQL data types that are specific to HCL OneDB™. To conform to the X/Open standards, you must use the X/Open SQL data type constants.

The DESCRIBE statement uses these constants to specify the data type of a column (or a return value) when you compile your program with the -xopen option.

The X/Open data type constants are defined in the sqlxtype.h header file.