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.
Determine statement information at run time
Handling statements that contain user-defined data types
SQL statements with opaque-type columns

SQL statements with opaque-type columns

For dynamic execution of opaque-type columns, keep in mind the following items:

You must ensure that the type and length fields of the dynamic-management structure (system-descriptor area or sqlda structure) match the data type of the data you insert into an opaque-type column.
Informix® ESQL/C truncates opaque-type data at 32 kilobytes if the host variable is not large enough to hold the data.

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.