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?
Numeric data types
The decimal data type supports the SQL DECIMAL and MONEY data types with the decimal data type. The decimal data type is a machine-independent method that represents numbers of up to 32 significant digits, with valid values in the range 10^-129 - 10⁺¹²⁵.

The decimal data type

supports the SQL DECIMAL and MONEY data types with the decimal data type. The decimal data type is a machine-independent method that represents numbers of up to 32 significant digits, with valid values in the range 10^-129 - 10⁺¹²⁵.

The DECIMAL data type can take the following two forms:

DECIMAL(p) floating point
When you define a column with the DECIMAL(p) data type, it has a total of p (< = 32) significant digits. DECIMAL(p) has an absolute value range 10^-130 - 10¹²⁴.
DECIMAL(p,s) fixed point
When you define a column with the DECIMAL(p,s) data type, it has a total of p (< = 32) significant digits (the precision) and s (< = p) digits to the right of the decimal point (the scale).

For a complete description of the DECIMAL data type, see the HCL OneDB™ Guide to SQL: Reference.