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.