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?
HCL OneDB™ ESQL/C data typesThese topics contain information about the correspondence between SQL and C data types and how to handle data types in the program.
Data conversion
Fetch and insert with host variables

Fetch and insert with host variables

If you try to fetch a value from a database column into a host variable that you do not declare according to the correspondence shown in Corresponding SQL and host variable data types, attempts to convert the data types. Similarly, if you try to insert a value from a host variable into a database column, might need to convert data types if the host variable and database column do not use the correspondences in Corresponding SQL and host variable data types. converts the data types only if the conversion is meaningful.

This section provides the following information about data conversion for fetching and inserting values with host variables:

How converts between numeric and character data
How converts floating-point numbers to strings
How converts BOOLEAN values to characters
How converts DATETIME and INTERVAL values
How converts between VARCHAR columns and character data

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.