Numeric data types

HCL OneDB™ database servers support the following numeric data types:

• Integer data types: SMALLINT, INTEGER, INT8, SERIAL, SERIAL8
• The Boolean data type
• Fixed-point data types: DECIMAL and MONEY
• Floating-point data types: SMALLFLOAT and FLOAT

These topics contain information about working with numeric data types:

• HCL OneDB ESQL/C data types to use as host variables for SQL numeric data types
• Characteristics of HCL OneDB ESQL/C numeric data types
• Formatting masks, which you can use to format numeric data types
• HCL OneDB ESQL/C library functions that you can use to manipulate numeric data types