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
Perform arithmetic operationsWhen performs an arithmetic operation on two values, it might need to convert data types if the two values do not have data types that match.
Operations that involve a decimal value
Convert the non-decimal numeric operand converts all operands that are not already DECIMAL (or decimal) to DECIMAL before it performs the arithmetic operation.

Convert the non-decimal numeric operand

converts all operands that are not already DECIMAL (or decimal) to DECIMAL before it performs the arithmetic operation.

The following list shows the precision and scale that uses for the non-DECIMAL operand.

Operand type: Convert to
FLOAT: DECIMAL(17)
SMALLFLOAT: DECIMAL(9)
INTEGER: DECIMAL(10,0)
SMALLINT: DECIMAL(5,0)

does not consider leading or trailing zeros as significant digits. Leading or trailing zeros do not contribute to the determination of precision and scale. If the operation is addition or subtraction, adds trailing zeros to the operand with the smaller scale until the scales are equal.