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.
Convert numbers to numbers

Convert numbers to numbers

If two values of different numeric data types operate on one another, HCL OneDB™ ESQL/C converts the values to the data type that the following table indicates and then performs the operation.

Table 1. Data types for which ESQL/C carries out numeric operations
Operands	DEC	FLOAT	INT	SERIAL	SMALLFLOAT	SMALLINT
DEC	DEC	DEC	DEC	DEC	DEC	DEC
FLOAT	DEC	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT
INT	DEC	FLOAT	INT	INT	FLOAT	INT
SERIAL	DEC	FLOAT	INT	INT	FLOAT	INT
SMALLFLOAT	DEC	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT
SMALLINT	DEC	FLOAT	INT	INT	FLOAT	INT

Data types for which ESQL/C carries out numeric operations shows that if HCL OneDB ESQL/C performs an operation between an operand with a data type of FLOAT and a second operand with a data type of DECIMAL (DEC), HCL OneDB ESQL/C generates a result that has a DECIMAL data type.