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.
What is Informix® ESQL/C?
Character and string data typesThese topics explain how to use character data types in the Informix® ESQL/C program.
Fetch and insert character data types
Fetch and insert lvarchar dataWhen an application uses a lvarchar host variable to fetch or insert a data value, Informix® ESQL/C must ensure that the value fits into the host variable or database column.
Fetch lvarchar data

Fetch lvarchar data

An application can fetch data from a database column of type LVARCHAR into a character (char, string, fixchar, varchar, or lvarchar) host variable. If the column data does not fit into the host variable, Informix® ESQL/C truncates the data. To notify the user of the truncation, Informix ESQL/C performs the following actions:

It sets the sqlca.sqlwarn.sqlwarn1 warning flag to W and the SQLSTATE variable to 01004.
It sets any indicator variable that is associated with the character host variable to the size of the character data in the column.

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.