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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, 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 HCL OneDB™ ESQL/C program.
Data conversion
Perform arithmetic operationsWhen HCL OneDB™ ESQL/C 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 operandHCL OneDB™ ESQL/C converts all operands that are not already DECIMAL (or decimal) to DECIMAL before it performs the arithmetic operation.

Convert the non-decimal numeric operand

HCL OneDB™ ESQL/C 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 HCL OneDB ESQL/C uses for the non-DECIMAL operand.

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

HCL OneDB ESQL/C 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, HCL OneDB ESQL/C adds trailing zeros to the operand with the smaller scale until the scales are equal.