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
An sqlda structureAn sqlda structure is a dynamic-management structure that can hold data that is either returned from or sent to the database server by a prepared statement. It is a C structure defined in the sqlda.h header file.
Handling an unknown column listYou can use an sqlda structure to handle the INSERT...VALUES statement
Execute a simple insert

Execute a simple insert

The following steps outline how to execute a simple INSERT statement with an sqlda structure:

Prepare the INSERT statement (with the PREPARE statement) and give it a statement identifier.
Set the columns to their values with C-language statements that set the appropriate sqldata fields in the sqlvar_struct structures of sqlda.
Execute the INSERT statement with the EXECUTE...USING DESCRIPTOR statement.

These steps are basically the same as those that handle an unknown select list of a SELECT statement. The major difference is that because the statement is a not a SELECT statement, the INSERT does not require a cursor.

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.