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

Fetch CHAR data

An application can fetch data from a database column of type CHAR or VARCHAR into a character (char, string, fixchar, varchar, or lvarchar) host variable. If the column data does not fit into the character host variable, truncates the data. To notify the user of the truncation, 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.