Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Data typesEvery column in a table in a database is assigned a data type. The data type precisely defines the kinds of values that you can store in that column.
Description of Data Types
DECIMALThe DECIMAL data type can take two forms: DECIMAL(p) floating point and DECIMAL(p,s) fixed point.
DECIMAL (p,s) Fixed Point

DECIMAL (p,s) Fixed Point

In fixed-point numbers, DECIMAL(p,s), the decimal point is fixed at a specific place, regardless of the value of the number. When you specify a column of this type, you declare its precision (p) as the total number of digits that it can store, from 1 to 32. You declare its scale (s) as the total number of digits in the fractional part (that is, to the right of the decimal point).

All numbers with an absolute value less than 0.5 * 10^-shave the value zero. The largest absolute value of a DECIMAL(p,s) data type that you can store without an overflow error is 10^p-s-10^-s. A DECIMAL column typically stores numbers with fractional parts that must be stored and displayed exactly (for example, rates or percentages). In an ANSI-compliant database, all DECIMAL numbers must have absolute values in the range 10^-32to 10⁺³¹.