Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® 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 Informix®. 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 Informix®. 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 Informix ESQL/C program with the -xopen option.

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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.